Announcement

Collapse
No announcement yet.

Mass conversion of access to excel/csv

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mass conversion of access to excel/csv

    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.

  • #2
    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
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment


    • #3
      Re: Mass conversion of access to excel/csv

      i used this method and it is working. Many thanks

      Comment

      Working...
      X