Importing xls data

D

Dave

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
 
D

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.
:)
 

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

Appending an existing table with imported Excel data 0
Excel Data Transfer Issue (strange situation) 1
Import Spreadsheet Problem 3
How to Import data from a different .xls file 2
Export to Excel 3
Import Individual Rows of Excel Data 4
Transferspreadsheet bring empty data from excel to access 2
cannot expand named range 1

Top