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
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
