troubleshooting Question

Importing or Linking Excel worksheet to Access as a table coming back with errors

Avatar of GPSPOW
GPSPOWFlag for United States of America asked on
Microsoft AccessVBA
6 Comments2 Solutions105 ViewsLast Modified:
I have a comma delimited txt and csv versions of a data set I am trying to either import or link in a MS-Access 2010 database.  The data set has over 100,000 lines.  This database was created in a pre-2003 version of Access but I have saved it to a 2010 version.

When I try to import the external data to the database, the 3rd field, FundCenter, does not copy over and I get NULL's at row 8550.  I have tried both the txt and csv versions of the data set and get the same result.  I have gone into the csv version and set the column to text without any success.  

I am trying to set up a macro to import the data automatically but if I cannot get it to work manually the macro is a mute point.

I have attached the txt file.  Can someone take a look and see what I need to do?


Join our community to see this answer!
Unlock 2 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros