Import Excel Data Into MS Access

This is the first in a series of video lessons where I demonstrate how you can share data between Excel and Access. In this lesson I show you how to Import, Append and Link Excel data to Access tables.

You initiate this process from inside Access. There are "Wizards" that guide you through each step in the process.

I invite you to visit my online shopping website - http://shop.thecompanyrocks.com - to view all of my videos and to explore the resources that I offer.

Danny Rocks
The Company Rocks

Category:

Education

Tags:

• Access Database
• Import Excel Data into Access
• Append data
• link to data source
• Field settings
• Microsoft Access
• Microsoft Excel
• Software Tutorial
• Educational
• Office
• Microsoft Office
• Business
• Training
• Computer Software

[kayjos79]

Dear Danny,

I watched your video on sharing data between Excel and Access and I like it. How do I get other parts of the video, am really trying to learn a lots of skills in Access.

Thanks.

[DannyRocksExcels]

@kayjos79

Hello - Thank you. I am pleased that you liked this video.

I have published a 7 hour DVD-ROM, "The 50 Best Tips for Access 2007." I offer it for sale at The Company Rocks online bookstore.

Danny Rocks

The Company Rocks

[waqid20]

Dear Danny,

I want to know how to change the auto number as I had made a software where the number must start from say 1846 then after that it goes on. Please help.

[DannyRocksExcels]

@waqid20

An "AutoNumber" is just tat - a Number that is Added to a new record "Automatically." It CANNOT be changed!

However, what you could do is use a "Make Table Action Query" to create a duplicate of the existing Table - without the AutoNumber Field.

Then - with the new table, go in and add in a new - Primary Key for your product codes - using 1846 (in your case) as the starting number.

Does this make sense to you?

Danny Rocks

The Company Rocks

[kverfla]

Danny, how you could import data based on the values in one column into another column. For example let's say you had an additional column in excel named "deposit" and had the names of the people who made the deposit as values, and you wanted to add them to MS Access AFTER the data for all other columns had already been imported. You would need to compare values and insert only the name on the corresponding row. Thanks in advanced for your reply.

[Hollywood118D]

Dear Danny,

I have two different tables of data in access with identical fields. Can you please tell me how to compare them so I can identify and remove the duplicates in the two tables. I do need to see the duplicates though. Please help.

Thanks

[TheMaxkuba]

Hi, we develop a software for this "Excel TO Access" please visit us via "software-development.iga-t.co­m"

[schoolboi180]

@DannyRocksExcels

Every time I send you a reply or a comment stating the problems that I'm dealing with seemed to be fixed, thanks, but as soon as I posted my previous comment my access decided to work.

[DannyRocksExcels]

@schoolboi180

Establishing the correct Relationships between tables is the key to using Access. The most common relationship is a One-to-Many. E.g. One customer can place Many orders. The Primary Key (CustomerID) in the customer table is related to the customerID field in the Orders table (One-to-Many)

I have published a DVD, "The 50 Best Tips for Access 2007." It contains @ 7 hours of video training.

I'll try to publish an Access tutorial later this wee.

Danny Rocks

[schoolboi180]

@DannyRocksExcels

Yea it seems that my professor, who wrote the instructions, didn't type what we should do when an error pops up, but I managed to get by. Now I have came upon another problem, we are being asked to combine two tables into a query, but every time I try I get some kind of mismatch error box popping up, I've heard maybe my relationships between each tables are the problem, but I've looked through the instructions twice and every thing is how it is suppose to be, any tips?