Forum home » Delegate support and help forum » Microsoft Access Training and help » Importing data
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Importing data
Resolved · High Priority · Version 2003
Reply Mon 23 Aug 2010, 15:02Delegate Jean said...
Jean has attended:
Access Introduction course
Importing data
I want to use the column headings as my field names when I am importing data fronm excel to access. It keeps saying there is an error. If I do not use the column headings the data is imported successfully. What is the problem?
Thanks
For upcoming training course dates see: Pricing & availability
RE: importing data
Hello Jean,
Hope you enjoyed your Microsoft Access course with BEST Training.
Thank you for your question regarding Importing.
When importing to Access you will usually get an option in one of the steps when using the IMPORT WIZARD, a box that you can tick saying "First row contains column headings".
That should give you the result you are are looking for.
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
RE: importing data
Hello Jean,
Hope you enjoyed your Microsoft Access course with BEST Training.
Thank you for your question regarding Importing.
When importing to Access you will usually get an option in one of the steps when using the IMPORT WIZARD, a box that you can tick saying "First row contains column headings".
That should give you the result you are are looking for.
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
|