Results 1 to 5 of 5
  1. #1
    aali is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2016
    Posts
    2

    Exporting from Access via CVS or XML file

    Hello,



    We want to export the data in our access database to a new system we bought. The vendor wants us create a XML or CVS file so that they can look at the data and assess what they need to do. We are not sure how to create a file of the data via XML or CVS. Can someone please let us know if this can be done and how and if it is easy? Thanks!

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Right-click on your table, select Export, choose either the "Text File" option (for CSV files) or the "XML File" option, and then the Export Wizard will walk you through it. You will need to do that for each table.

    Note that the XML option gives you the ability to include a Schema file to go along with it, and includes field names in the Export. So that option may be more informative/useful for your vendor.

  3. #3
    aali is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2016
    Posts
    2
    Thank you JoeM. I will try and let you know what happens. Take care.

  4. #4
    Callahan is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    25
    Hello JoeM
    When I Right-click on a table, Export is not an option. Import is available but not Export. Why do you suppose this is?????

    Thanks
    Callahan

  5. #5
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    When I Right-click on a table, Export is not an option. Import is available but not Export. Why do you suppose this is?????
    Never heard of that problem, and cannot find anything about that out on the internet.
    Is it a native table or a linked table?
    How big is the table?
    Is there any security on the database?
    Have you applied all Microsoft patches?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access shuts down when exporting to text file
    By mgrlvr in forum Import/Export Data
    Replies: 21
    Last Post: 11-16-2015, 09:59 AM
  2. Exporting a Access Report to an Excel File
    By Coffee in forum Import/Export Data
    Replies: 2
    Last Post: 07-28-2014, 11:32 AM
  3. Replies: 7
    Last Post: 04-18-2014, 05:26 PM
  4. Need help exporting large Access file into Excel
    By phidelt in forum Import/Export Data
    Replies: 2
    Last Post: 02-27-2013, 06:14 PM
  5. Exporting table from access to text file
    By narendrabr in forum Import/Export Data
    Replies: 3
    Last Post: 01-08-2013, 09:59 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums