Runtime error 2391

P

PYTAI

Joined
May 26, 2006
Messages
1
Reaction score
0
I am new to Microsoft Access , currently i have a macro written in VB. it has to import Excel sheet to Access table. But when i try to browse & select the file , when i click run, it will always show that .

Runtime error 2391 , "Field 'Part Number' not exist in the table 'tblavl.' .

The command is as below.

DoCmd.TransferSpreadsheet acImport, 8, "tblAVL", txtImport.Text, True, "A:Z"

Hope you can help to give me some advice..

rgds.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I import an unstandard Excel worksheet into Access 2007? 3
Import delimeter file into existing table? 15
Error 2391 5
Transfer Spreadsheet 3
Import Add 1
Run time error 2391 when exporting Access table using VBA in Excel 1
Automating Importing 2
how do I debug access script? 3

Top