.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?
Frank VertinAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.