Convert Excel file to Access file

I need to convert an Excel 2016 file into an Access 2016 file.  The Excel file has 4 colums and multiple rows and 2 sheets.  Is there a way I can import this information into Access and have it converted into a database file without having to retype all the information?
LVL 2
RyanHelp DeskAsked:
Who is Participating?
 
NorieConnect With a Mentor VBA ExpertCommented:
You could easily import the data from the 2 sheets into an Access database by going to External Data>New Data Source>From File>Excel.

That's not really going to make a 'proper' database though, that would need further work.

What exactly do you have in Excel and what exactly do you want to do with it in Access?
1
 
Scott CSenior Systems EnginerCommented:
The steps to convert Excel to Access are in this blog.

https://www.thoughtco.com/convert-excel-spreadsheet-access-2013-database-1019967

There are also videos on YouTube to do this as well.

Here's one...https://www.youtube.com/watch?v=0ekQBmvbwdc
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.