Creating a new Access database from an Excel spreadsheet in Office 2003
To export the table to Excel and create the database in Access Open the Northwind sample database.
I can’t find the Northwind.mdb database file
The default folder location of the Northwind sample database is as follows, for these versions of Access:
Access 2003 \Program Files\Microsoft Office\Office11\Samples
Access 2002 \Program Files\Microsoft Office\Office10\Samples
Access 2000 \Program Files\Microsoft Office\Office\Samples
Export the Employees table to an Excel 97-2003 (*.xls) file by clicking Export on the File menu, and then clicking Microsoft Excel 97-2003 (*.xls) in the Save as type box.
Note In Access 2000, select file type Microsoft Excel 97-2000. In Access 2002, select file type Microsoft Excel 97-2002 (*.xls).
Close and then restart Access.
Click Open on the File menu.
Click the arrow to the right of the Look in box, select the path to the Excel file, and then double-click its icon.
On the first page of the wizard, select the First Row Contains Column Headings check box, and then click Next. If you are not using Northwind.mdb, be sure to select the check box only if your data contains column headings in the first row.
On the second page of the wizard:
If you are linking data, type a name for the new table in the Linked Table Name box, and then click Finish.
If you are importing data, click In a New Table, click Next three times to accept the default values, and type a name for the new table in the Import to Table box. Click Finish.
Access creates and opens a new database. If you used the Link Spreadsheet Wizard, Access linked the data in the Excel spreadsheet file to the new table. In the following graphic, notice the icon that designates it as a linked table from Excel. If you used the Import Spreadsheet Wizard, Access imported the Excel spreadsheet as a new table
October 11th, 2008 at 11:43 am
[...] Original Brick ONeil [...]