Importing Spreadhseets into database

Hi Gregory, thanks for your query. Unfortunately the import wizard uses the column headings in Excel to map onto the same field name in Access and there is no way to get round that using the wizard. However I would recommend a two-step work-around. Set up a separate table in Access linked to the spreadsheet data, then use an append query to remap the fields in that table onto one of your choice. Set up correctly this could work quite seamlessly.

Hope this helps,

Anthony