Access to SQL Server Converter with Field Mapping
Move Microsoft Access tables into SQL Server, Azure SQL, MySQL or PostgreSQL without writing export scripts or retyping data. Map fields visually, filter records, and repeat the same conversion with one click.
Try It Free for 14 Days See Plans & Pricing14-day free trial · 20 conversions, first 500 records each · no credit card
How it works
Four steps from an Access database to SQL tables
Load or build a config
Start from a saved .cfg conversion configuration or create a new one.
Select the formats
Choose Microsoft Access as the input and SQL Server (or MySQL or PostgreSQL) as the output.
Map the fields
Auto-map by name, or assign any input field to any output field manually.
Convert
Click Convert, then save the configuration so the next run is one click.
What you get
No Access installation required
You do not need Microsoft Access or the full Office suite on the PC doing the conversion. You need the free Microsoft Access Database Engine 2016 Redistributable, available from Microsoft.
Field-level mapping
Map any input field to any output field, with truncation and padding handled automatically.
Filter before you convert
Match on equals, not-equals, LIKE patterns, numeric comparisons or empty fields, and combine rules with AND / OR.
Works with your SQL Server
Connects to on-premises SQL Server (2012 and later), SQL Server Express and Azure SQL Database through ODBC Driver 17 or later. Windows Authentication is supported for SQL Server.
Large tables
Built for high-volume batch work, with conversions of 100,000+ records per pass.
Schedule it
Run file-to-SQL and SQL-to-file conversions from the command line with no GUI, then schedule them as Windows batch jobs. SQL-to-SQL is not supported in headless mode.
Two-way
Any of the nine supported formats can be input or output, so SQL Server to Access works the same way.
Related
Other conversions
DBF to SQL Server · CSV to SQL Server · Complex Routing · Compare with other tools
Questions
Access to SQL Server: common questions
Do I need Microsoft Access installed?
No. You need the free Microsoft Access Database Engine 2016 Redistributable from Microsoft. The full Microsoft Office or Access suite is not required.
Does it work with Azure SQL?
Yes. SQL Server mode connects to Azure SQL Database, on-premises SQL Server and SQL Server Express using ODBC Driver 17 or later.
Do I need to write SQL?
No. Mapping and conversion are visual. A free-form SQL query tool is available if you want it, but it is optional.
Is my data uploaded anywhere?
No. Universal File Converter is a native Windows desktop application (Windows 10 and 11, 64-bit). Files are processed on your own computer; no browser or cloud service is required.
Can I try it first?
Yes. The free trial lasts 14 days with no credit card. It is the Standard edition, limited to 20 conversions of the first 500 records each, and it can be used once. Purchases carry a 30-day money-back guarantee.
Stop exporting Access tables by hand
Standard $19.99 per month, Lifetime $249.99 one-time, or Professional $49.99 per month per site. Start with the free trial.
Try It Free for 14 Days Converting CSV files instead?