By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,730 Members | 1,659 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,730 IT Pros & Developers. It's quick & easy.

Saved imports are not working

100+
P: 453
I have a back and restore function in my program. The backup section works great it creates a .txt file for each table. I can then do a restore using the docmd.transfertext acImportDelim command this has been working fine until yesterday and now any of my saved imports are not found. I can look in the Saved Imports and they are there but when I run the backup I get an error "The text file specification "Import-params" does not exist. You cannot import, export or link using the speciaication"
Expand|Select|Wrap|Line Numbers
  1. DoCmd.RunSQL (StrSql)
  2. Vtable = "params"
  3. apppathx = (StrFolderName + "params.txt")
  4. DoCmd.TransferText acImportDelim, "Import-params", Vtable, apppathx, True
I've imported the .txt manually and then saved it but it still gives me the error message.
I've compact and repaired the database and have also rebuild the complete program and it still isn't working.
I could sure use some help
Thanks
1 Week Ago #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.