Solved

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

Posted on 2014-10-14
3
208 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 34

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

896 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now