Hello,
I'm looking for some help.
Working in Access, i'm trying to pull data from a .txt file to populate cells in a table on another file.
This is the command i'm using:
I'm getting an error because this command seems to only work while pulling from an excel file.
Please Login or Register to view this content.
How would i get it to work to pull from a .txt file?
Any help would be appreciated!
Thanks,
Paul
Last edited by alansidman; 11-12-2015 at 10:40 AM.
You are using the Specification as "testnew." Have you set this specification up in the Advanced section of the importation procedure?
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hello alansidman,
I did not-- and now that I did, it worked.
Thanks you.
Is there an alternate way to accomplish the same task? As in within the code itself? Or would I have to change the importation procedure every time?
Thanks,
Paul
AFAIK, you have to set the specification each time you have a different layout for your text file. If you are doing one time imports then use the wizard import and not rely upon VBA.
An alternative to using the import specification is to create a Schema.ini file which you locate in the same directory as the file you want to import - but as with the specification it needs to match the file being imported - including the file name so probably no benefit. Google schema.ini and access to find out how to use it. Here is an example link
https://support.microsoft.com/en-us/kb/149090
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks