View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Excel to Access *.MDB conversion

Greetings from Virginia, USA, near Washington DC.

The jump from Excel to Access should be clean and straightforward,
particularly if the Excel file is a flat file. If you'll open an
Access database, from the Tables view click New and then select Import
Table from the window. Choose the location and specify the .XLS
format, and the Excel file should appear in the Tables view.

If I may suggest, open the table after the import to make sure that
things have gone the way you prefer. From your description, though, it
should be easily done.