convert linked table

[ndendrinos]

Hello,
I have linked an excel sheet to access
From within access how can I convert the linked table to a regular access table.
Microsoft shows how for access 2003 but not for 2002

The excel sheet has 92 headers on one row and that is all I'm trying to export to Access but I am unable to do it by importing external data from within access ... the import fails ... all headers in excel are formated "text"

[CreganTur]

Try the DoCmd.TransferSpreadsheet method- you can use it to automatically import records from Excel into an existing Access table. If that doesn't work, then I would suggest creating an ADO recordset off of the Excel file and use the .Execute method inside a records loop to load each record into the table.