Delete column Headings

[Chimp8471]

I have just set up a macro to import some info from Excel, all works well, but i keep getting 4 blank columns on theend of my data, is there a simple way that i can remove these columns, within my macro or by using a delete query

 

[IMO]

Create a delete query with the condition 'IsNull' and run it after the import

IMO

 

[IMO]

I think I may have misunderstood, do you mean "columns" or "rows" at the end of the data?

IMO

 

[Chimp8471]

columns.........i just tried your previos option and it deleted all the rows, so glad your back

 

[IMO]

Are you importing to a table that's already in your DB? If so, make sure all column Names in the spreadsheet are identical to those in the table and you shouldn't get extra columns. Just one other thing to check, make sure there is no 'duff' data in the spreadsheet by selecting all the last columns and deleting.

IMO