Can you merge information from an excell spread sheet into an Access database that has been built specifically to accomodate the spread sheet info?

Hello Paul,

Hope you enjoyed your Microsoft Access course with BEST STL Training.
Thank you for your question regarding merging info from Excel to Access.

What you are sugggesting is possible. There are several ways to do this.

The first way would be to simply import the data directly into access. Try FILE > GET EXTERNAL DATA > IMPORT.

Then simply point the database to your Excel file, and import the data. The table will import and format itself to meet your data structure, within reason. Any errors will be reported in a separate table.

Alternatively, if your data is EXACTLY the same structre as your database table (field types) then you can copy and paste it directly into the database. Would not recommend unless you are very sure that there are no differences.

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