Importing from an excel worksheet to access form
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
Software/Hardware used:
Software/Hardware used:
ASKED:
August 1, 2008 5:36 PM
UPDATED:
August 2, 2008 9:49 AM
Answer Wiki:
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 <a href="http://www.exceltip.com/st/Export_data_from_Excel_to_Access_(DAO)_using_VBA_in_Microsoft_Excel/426.html">export data from excel to Access</a>. To have an idea of the script, click on the link: http://www.exceltip.com/st/Export_data_from_Excel_to_Access_(DAO)_using_VBA_in_Microsoft_Excel/426.html
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
