?
Solved

Bulk csv import to Access 2003

Posted on 2004-09-02
3
Medium Priority
?
711 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 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 500 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

621 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