Problems importing an excel worksheet into an existing access data

G

Guest

I am getting an error importing an excel worksheet into an existing access
database table. I think it may be that I have yes/no fields in my access
table and I am unable to format the worksheet this way using the custom type.
Any suggestions of what else I may be missing in my import file?
 
V

Van T. Dinh

For the Excel column that corresponds to the Access/JET Boolean Field, you
can use 0 for False / No and any other numeric value, preferably -1, as
Yes/True.
 

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 to import excel data into an existing table 1
Importing text into number field- Error 4
importing a worksheet info to an existing access table 2
Problems Importing Excel Files to an Existing Table 1
Importing data from excel spreadsheets 11
Importing data from Excel into an existing Access table? 1
Importing Data into Access 2003 - Data disappears 1
Importing Excel Data into MS Access Table 1

Top