i'm trying to automate the import of an excel spreadhseet into Access 2000. The following code does so and imports this into a table called 'New'. However as you can see i have put the full path of where the spreadsheet is to be located everytime a user wants to import it.

What i need is this to be a dialog box that appears (on push of a button) where you can browse and choose the file wherever it may be located. I have tried adding a MS common dialog control but it says i do not have the activeX license, is there any other way around this?? Many thanks

'''''''''''''''''''code
DoCmd.TransferSpreadsheet acImport, , "New", _
"C:\Documents and Settings\Nick Williams\My Documents\My Databases\SupplierParts.xls", _
True, "A:C"
'''''''''''''''''''''