Importing csv file using saved text specification layout

[leeloo0505]

Hello..

I am trying to code the importing of a .csv file using a text specification I already created within the Database using Import/Advanced/SaveAS..
when I run the following code I get an error stating:
Runtime error: 3625
"the text file specification 'DowntimeToolImportLayout' does not exist. You cannot import, export, or link using this specification. I have checked the spelling and ensure the 'DowntimeToolImportLayout' is there.. it's listed in the SPECS listing when importing a new file. The line of code is:

docmd.transfertext acImportDelim, "DowntimeToolImportLayout", "tblDowntimeToolImport", "K:\fixed\data\downtime\cust_ord_post\20031008_cust_ord_post_2042_p1.csv", True, "", 28591


Anyone have any ideas?
leeloo0505

 

[leeloo0505]

I should add..I am coding this in Excel so a user who does not have Access can import the outside .csv into the DB.. once I get that then I do know how to pull the needed data into Excel.. I just can't get Excel to read the text file specification that is created in the DB I have successfully opened in earlier code.
I put the code straight in Access and it works fine, adjusted my references in Excel to include MS Access Objects but still will not work from Excel?

Thanks,
leeloo

 

[dk]

Hi,

Please don't post the same questions to different forums - it leads to people wasting their time duplicating an answer. I've replied to the thread you posted in the Excel forum so please keep the discussion going there.

Thanks

Dan

 

[leeloo0505]

Sorry Dan for the multiple posts but I got a private message in all caps (yelling I presume) to put this on the Excel board.. sorry for the confusion.

 

[NateO]

Hello,

Indeed this thread is locked, here's the discussion in question:

http://www.mrexcel.com/board2/viewtopic.php?t=65726

No worries leeloo. We do like to keep the same discussion in one dialogue, a thread, if you will. If someone's sending you PMs about moving a thread and you believe they are correct, please contact an administrator or moderator and the thread will be moved. If you don't agree, please respond to the sender, only if you want to, as courteously as possible and/or contact an administrator or moderator regarding the matter.

Also, for those telling others where their posts really belong, perhaps a discussion with an administrator or moderator is more appropriate, versus unilateral action, which in this case lead to duplicate threads, probably more dysfunctional.

This is a great board, thanks everyone.