I am using the import function in Access to import data from Excel to Access. I use the usual Get External File, choose the appropriate sheet, let Access assign the ID, and so on.
My original records in Excel only have 43 rows including the column heading. The problem now is that the table created in Access somehow extends the list to ID 64999, so I have all these blank rows from row 43 to 64999.
My table in Excel has no empty rows nor column, i.e. all of the relevant range in the sheet are filled with values. I have a few lists with many '0.0' values but I don't think that is the problem.
Before the import, I actually have a macro which converted the data into this list format so that they can be imported in Access. I'm not sure if that might be the cause..?
Can anyone enlighten me on how I can make all these blank rows disappear? I have done this importing before with other files and usually they work fine.