Importing from an Excel worksheet to Access form

5 pts.
Tags:
Microsoft Access
Microsoft Access forms
Microsoft Excel
Microsoft Excel spreadsheet
I have set up my database in access including the form that I want to import my information into, however when I try to import from an excel worksheet into access, it changes all my field names to field 1,2,3 etc. Then when I look at the form page all my sections have the word #NAME? in them. How can I import without access changing my headings? I need it to just import my information the way that I have requested. Thank you

Answer Wiki

Thanks. We'll let you know when a new response is added.

There are two ways of doing it:
First is:
1. In Access, point to Get External Data on the File menu, and click either Import or Link Tables.
2. In the dialog box that appears, browse to and select your Excel file, and click either Import or Link.
3. On the first page of the wizard, select the First Row Contains Column Headings check box, and then click Next. Be sure to select the check box only if your data contains column headings in the first row.

And the second is by using VBA and writing a script to export data from Excel to Access.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following