98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Importing data
Importing data
Resolved · High Priority · Version 2003
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
Mon 23 Aug 2010, 15:54Trainer Richard said...
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
Mon 23 Aug 2010, 15:54Trainer Richard said...
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
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. |
Access tip:Duplicating an EntryTo duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field. |
