Solved

Bulk csv import to Access 2003

Posted on 2004-09-02
3
688 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 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

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

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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…

710 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