Problems importing an excel worksheet into an existing access data

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
Back
Top