Solved

Bulk csv import to Access 2003

Posted on 2004-09-02
3
677 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
  • 2
3 Comments
 
LVL 65

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 65

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

777 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