CODEWITHSUNDEEP
excelms-access
user366312
user366312

Reputation: 16988

Is there any freeware tool available to convert MS Excel files to MS Access DB files?

Is there any freeware tool available to convert MS Excel files to MS Access DB files that woks for both 2003 and 2007 formats?

Upvotes: 1

Views: 453

Answers (2)

ta.speot.is
ta.speot.is

Reputation: 27214

If you have Access running on the computer you can open the spreadsheet in Access to create a new database from it, or use "Import Data" to import the Excel spreadsheets into tables. If it's a big deal, use Office Automation to speed the process up.

Otherwise, the Access Connectivity Engine (ACE) is an ODBC driver that can connect to both Access and Excel files. You could write something to transfer data between them. It's free but a bit of work.

Alternatively you could use SSIS, which is also free with SQL Server Express edition. But certainly a lot of overhead just to convert between files.

Upvotes: 3

nhinkle
nhinkle

Reputation: 1157

You can do this right from Microsoft Access. Click File > Open, and set the filetype to Microsoft Excel Workbook, then open the worksheet.

A wizard will then appear to guide you through importing the workbook into a database. You can set which sheet to use for the database, which columns should be used, whether the data has headers, etc. This should work for any excel file.

Upvotes: 1

Related Questions