Solved

Bulk csv import to Access 2003

Posted on 2004-09-02
3
694 Views
Last Modified: 2012-06-27
Hello

I was wondering if there is a way to bulk import csv files into different tables within one access 2003 database?

Can this be done programmatically? VBA?

Thanks

Herschel
0
Comment
Question by:Herschel_Solomon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 66

Expert Comment

by:Jim Horn
ID: 11964364
Create Import Specs manually to cover each import, give them a name, then write VBA code that performs all imports using...

DoCmd.TransferText acImportDelim, "Spec Name", "Destination Table Name", "File Name.csv"

Hope this helps.
-Jim
0
 

Author Comment

by:Herschel_Solomon
ID: 11964779
Hello Jim

Thanks for your feedback,

I’m new to access so please excuse if this sounds silly.

How do I create an import specs? As an example all my csv files will all be on my local PC under a directory called C:\Server_reports. The csv files will be named server1_A.csv, server2_A.csv, server1_B.csv serverC.csv etc etc. (it’s pretty random now that I think of it)

Also these server csv files will be produced on a monthly basis, I would like a table for every server however every monthly import should append data to the existing tables.

Any help on this will be much appreciated.

Thanks

Herschel
0
 
LVL 66

Accepted Solution

by:
Jim Horn earned 250 total points
ID: 11964863
File:Get External Data-Import, then select your .csv file, then there'll be an 'Advanced' button on the lower left.  Hit it and follow instructions.

Explaining beyond this is probably outside the scope of a single EE question.  Best advice I can give is to find an Access manual that describes it.  My favorite is the Litwin/Getz 'Access {your version} Developers Handbook'.

Might not be a bad idea to hire a contractor in your local area to set this up, then teach you Import Specs and VBA coding so you can maintain it. You'll be amazed how fast you can pick this stuff up with the right coach.

Hope this helps.
-Jim

0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question