import excel spreadsheet without empty rows (causing nulls)

  • Thread starter Mitchell_Collen via AccessMonster.com
  • Start date
M

Mitchell_Collen via AccessMonster.com

Hi.

I am trying to import an excel file into access. The import goes fine or so I
thought. When I opened the table it had all my excel data plus over 9000 null
valued records.So instead of getting a record set number of 200 records, I
got over 9200. I have re imported the table after deleting empty rows (<-it
felt pointless because there was nothing that I was deleting, I just figured
there was something hidden) in the spreadsheet but it did the same thing. Is
there something that attaches to the spreadsheet that causes null records?

Please let me know if you know what has happened.
Thanks, Misty
 
M

Mitchell_Collen via AccessMonster.com

***
I accidentally posted in wrong group. Sorry about that. -Misty :)
 

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

import excel spreadsheet without empty rows (causing nulls) 4
Transferspreadsheet bring empty data from excel to access 4
Nulls vs. blanks? 4
Import From Excel from unusual range of rows 2
Import Excel To Access 3
Excel 2007 spreadsheet - blank rows 2
Importing data from excel spreadsheet 1
Load a CSV into an empty, formatted XLS? 15

Top