Import from Excel 1

[JimmyRa]

I want to import data from Excel, but let the user check if it is OK on the way in. I have tried throwing it into a tmp table, and listbox to allow them to pick and load. Access, of course loads all the empty lines from the Excel, and doubles up lines in the tmp table as well.
I tried deleting the tmp table before each run, but it complains about that, if it the table is not there.
Can I check if the table is present, before doing a delete?
Is there a better way to do all this ?

 

[MrBillSC]

Create a query to delete all the records from your temp table. Then manually import the records from excel and save as a specification. Finally create a macro that opens the delete query and then transfers the text using the saved specification.

MrBIll