docmd.transfertext

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Hi,

I use the docmd.transfertext method of importing a delimited file into my db
using A97 the file names extension is .log

i converted my db to A2000 and now this doesnt work

I tried changing the file extentino to .txt and the file name in the command
to .txt and it worked.

Why does A2000 not like importing a .log and how can i get around this?


thanks for any help

ps. I have installed SP3
 
Try creating a macro that imports your .log file and then assigning that macro to a command button.I have also came across the same problem with similar files.If you import these files on a regular basis,create a .bat file on your desktop that copies your .log file to a .txt file..

Hope this will help.....
 
Back
Top