dbTalk Databases Forums  

3001 error in importing acsii delimited files

comp.database.ms-access comp.database.ms-access


Discuss 3001 error in importing acsii delimited files in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
CJ
 
Posts: n/a

Default 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

Reply With Quote
  #2  
Old   
CJ
 
Posts: n/a

Default Re: Solved Problem - 12-01-2003 , 05:08 PM






I posted to another message board and I was told to compact my
database. This worked.

Christy

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.