Solved

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

Posted on 2014-10-14
3
241 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
[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
3 Comments
 
LVL 58

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 38

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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

617 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