Mass conversion of access to excel/csv

Home Forums Office Office XP / 2003 General Issues Mass conversion of access to excel/csv

This topic contains 2 replies, has 3 voices, and was last updated by Avatar DrugTMlin 5 years, 9 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • Avatar
    rrk83
    Member
    #162997

    Hi All,

    Could anyone please suggest a solution/software to do mass conversion of 8000 Access 2002 records to excel/csv format? I have read Microsoft article for exporting Access records to excel format, but this procedure takes lot of time to export 8000 Access records. So my company is willing to pay for any software that does this job easily and accurately. Many Thanks in advance.

    Avatar
    Ossian
    Moderator
    #189224

    Re: Mass conversion of access to excel/csv

    If it is a one off, just copy and paste from access into Excel, then save to CSV

    Otherwise possibly an Excel macro to open a data connection to Access, query the records and insert them into a new spreadsheet, again saving as CSV

    Avatar
    DrugTMlin
    Member
    #389579

    Re: Mass conversion of access to excel/csv

    i used this method and it is working. Many thanks

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.