troubleshooting Question

Importing data using Access 2007

Avatar of Juneaucounty
JuneaucountyFlag for United States of America asked on
Microsoft Access
10 Comments1 Solution3099 ViewsLast Modified:
I have created a text file specification using the import wizard in Access 2007. I want to automate this process and have the user run a macro which will make a call to a vb fuction. In my code see below I use the name of the import specification as one of the function arguements. When the macro runs I receive an error stating the text file specification does not exist. When I go into access I can see the specification I saved.
Function importData()
       DoCmd.TransferText acImportDelim, "TXMAST1", "TXMAST", "TXMAST.txt"
End Function
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 10 Comments.
Join the Community
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 1 Answer and 10 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