Solved

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

Posted on 2014-10-14
3
216 Views
Last Modified: 2014-10-15
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
Comment
Question by:Frank Vertin
3 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 40380642
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
 
LVL 35

Expert Comment

by:PatHartman
ID: 40380787
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
 

Author Closing Comment

by:Frank Vertin
ID: 40382562
This is all good information.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
I suddenly cannot write to C drive 20 74
Modal form 11 30
Why get error when delete all records on a sub-form 2 15
Switch 5 16
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
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…
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…

770 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