Import with unwanted blank fields

[Ssstacey]

Hi,
Im trying to import a spreadsheet from Excel. I use the wizard and I get the sheet imported. The only problem is that I get additional blank fields in my table in Access. How can I make sure that this does not happen? I want to keep on importing into the same table, so these useless empty fields keep on accumulating.
Any help?
Thanx,
Stacey

 

[statsman]

The empty fields don't just occur, they are coming from somewhere on your Excel spreadsheet. Double check the spreadsheet. There may be empty columns or rows used as separators. Get rid of them and it should solve your problem.

 

[neileg]

There must be something in the apparently empty space in the spreadsheet. You could try deleting columns to the right of your data. Otherwise, define a range to include your data and specify the range for the import.