Importing xls data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,
I'm using the TransferSpreadsheet function in a macro to import data from an
Excel 97 spreadsheet into an Access 97 table. The destination table does not
have a primary key and it does not have any fields with the Required value
set to Yes.
My problem is that once every so often, a small number of rows on the
spreadsheet may have one or two columns left blank. These rows are not being
transferred. Is there a better way to make this transfer work without having
to check through the spreadsheet for blanks?
Thanks in advance.
Dave
 
Hi,
I managed to find a solution:
Setting certain fields to Allow Zero Length Strings allowed the data to come
through.

Thanks for taking the time to read the post.
:)
 
Back
Top