3001 error in importing acsii delimited files -
12-01-2003
, 09:48 AM
Hi Everyone,
I'm using a database that someone else developed for my company and
now I have an error with it. When I click on a button that will
import ascii delimited files into the database I get a "Run-time error
'3001'Invalid arguement" When I click on the debug button this line
is highlighted "FileCopy "c:\a7110\data\10sbr3-5.asc",
"c:\a7110\data\10-3-5.asc" DoCmd.TransferText acImportDelim, ,
"type10_old", "c:\a7110\data\10-3-5.asc", True"
The lines before and after this line are:
If Dir("c:\a7110\data\10sbr3-5.asc") <> "" Then
FileCopy "c:\a7110\data\10sbr3-5.asc", "c:\a7110\data\10-3-5.asc"
DoCmd.TransferText acImportDelim, , "type10_old",
"c:\a7110\data\10-3-5.asc", True
End
---------------
If I mark these lines out with ' to comment them out, then the next
FileCopy line errors out and this line is the same as the above but
just with a different file name. This button has worked fine before
and we have done nothing to the database to change it in any way.
System is Windows XP Professional, Microsoft Office XP.
Thank you.
Christy |