Import from Excel fails after A97/A2K conversion

[david epsom dot com dot au]

300 sConnect = "[Excel 8.0;HDR=YES;DATABASE=" & sFile & "]" & sTable
310 Codedb.Execute "INSERT INTO tblCB_Cashbook_Import SELECT * from " &
sConnect & ";", DAO.dbFailOnError


After conversion from A97 to A2K, the Import fails with message:

Field 'tblCB_Cashbook_Import.strCreditor' cannot be a zero-length string.

Same spreadsheet: blank fields were accepted as null by A97, but rejected by
A2K.

Offhand, I can't think of any convenient way to make the import work again.
We will have to change the tmp table field specifications, and run a whole
series of update queries to convert the blank fields to null before merging
with the destination table.

Any suggestions?

 

[GVaught]

In Access change the field in question to all zero length. Look for this in
the table design.