Run-time error '31519'

[JFKJr]

HI!, I am trying to import an excel file to an Access table using the following code, but I am getting "Run-time error '31519':You cannot import this file" error.

Function Import_ExcelFile()
DoCmd.TransferText acImportDelim, , "ImportedData", "C:\ExportFile\Test_file.xls", True
End Function

I am using Access 2003 database.

Please kindly help me what to do. Any help would be greatly appreciated. Thanks in Advance.

[ADezii]

I think you are looking for the TransferSpreads heet Method and not TransferText.

[JFKJr]

I think you are looking for the TransferSpreads heet Method and not TransferText.

Yes, I got it thanks anyway for the reply.

I have successfully imported an excel file into an Access table, but now I am facing another problem i.e., the table has an empty field (field with no data). I am having trouble to delete this empty field using Access VBA code. Do you have any idea about deleting an empty field in an Access table?

Any help would be greatly appreciated. Thanks.

[ADezii]

Yes, I got it thanks anyway for the reply.

I have successfully imported an excel file into an Access table, but now I am facing another problem i.e., the table has an empty field (field with no data). I am having trouble to delete this empty field using Access VBA code. Do you have any idea about deleting an empty field in an Access table?

Any help would be greatly appreciated. Thanks.

Oddly enough, I just replied to a similar Thread, have a look. BTW, why not simply Delete the Field manually?

http://bytes.com/forum/thread821246.html

P.S. - Kindly keep the Threads separate from each other.

[JFKJr]

Oddly enough, I just replied to a similar Thread, have a look. BTW, why not simply Delete the Field manually?

http://bytes.com/forum/thread821246.html

P.S. - Kindly keep the Threads separate from each other.

Sorry for the two posts, I actually posted the same question twice in my two separate threads. I got your reply from the other post. Thanks!