Import

T

Toby

Open the database. From File --> Get External Data -->
Import. Select the excel file. Afterwords a wizard comes
up allowing you to change the fields for the table, you
can click on the advance button to see and edit these
fiels to make them text or anything you desire. I am using
Access 2003 so hope it is same for previous versions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Error Saving Import/Export Spec 1
No *.xls selection to import 3
Import from notepad Pipe delimited text document 1
Office 2003 -> Office 2007: Import Data fr Access into Excel 0
Creating an Import Spec – Advance button missing? 6
|9 can't find the field '|' Error when importing a csv to Access 2 1
Importing Data with | as the delimiter in Access 2007 3

Top