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?
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?
Scott CSenior Systems EnginerCommented:
The steps to convert Excel to Access are in this blog.

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

Here's one...
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.