Laura has attended:
Access Introduction course
Access
How do I export a databse created in excel in to new Access 2007 database?
RE: Access
Hello NAME,
Hope you enjoyed your Microsoft Access course with BEST Training.
Thank you for your question regarding exporting a database created in excel in to new Access 2007 database
On the External Data tab, in the Import group, click Excel.
In the Get External Data dialog box, click Browse.
Use the File Open dialog box to locate your file.
Select the file, and then click Open.
In the Get External Data dialog box, ensure that the Import the source data into a new table in the current database option is selected.
Click OK.
The Import Spreadsheet Wizard starts, and asks you a few questions about your data.
Follow the instructions, clicking Next or Back to navigate through the pages. On the last page of the wizard, click Finish.
Note Access asks whether you want to save the details of the import operation that you just completed. If you think that you will be performing this same import operation again, click Yes, and then enter the details. You can then easily reproduce the operation in the future by clicking Saved Imports in the Import group on the External Data tab. If you don't want to save the details of the operation, click Close.
Access imports the data into a new table, and then displays it under All Tables in the Navigation Pane.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Richard
Microsoft Office Specialist Trainer
