• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

.csv files; How does a person load them into MS Access?

I've loaded them into Excel95, but not since then. Now the request has come to make Access 2010 out of them. Can you help or at least point me in the right direction?
0
Frank Vertin
Asked:
Frank Vertin
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Well as a start, it's external data, import, Text file on the ribbon.

Then follow the wizard.  Depending on the file and how well formatted it is, will determine the level of your success.  It can be that you need to resort to VBA to get the job done.

Once you have that, you'll have a single table, which will be a "flat file" of data that may need to be normalized (broken up into various tables) in order to work with it well.

Jim.
0
 
PatHartmanCommented:
DoCmd.TransferText is the method used if you need to automate the procedure.  In general, import the file first using the interface as Jim suggested.  Once you know you can import the file correctly, you can save the import spec which will record any settings you had to tweak to get the data.  Then you can automate later imports by using the saved import spec in the TransferText method.
0
 
Frank VertinAuthor Commented:
This is all good information.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now