Slow Data Upload from MS Access to SQL Server - Need Help!

[wellsw]

Subject: Slow Data Upload from MS Access to SQL Server - Need Help!

Hello everyone,
I have been creating and managing a Microsoft Access database for the last 10 years. Over time, it has grown significantly in size and user base. Recently, I decided to migrate to an AWS-hosted SQL Server to better handle the load and scalability.
While I can connect to the SQL Server, transfer data, and run queries against it without any issues, I'm facing a significant problem with upload speeds. Specifically, uploading a table with approximately 7,000 rows takes about 10 minutes. However, downloading data from the SQL Server to Access is almost instant.
To isolate the problem, I created a fresh database with just one table containing about 7,000 rows. I also set up a corresponding table in SQL Server for the transfer. The upload still takes an unusually long time, but when I run the same upload process using SQL Server Management Studio (SSMS), it completes almost instantly.
Here are some details about my setup:

• Using the latest version of MS Access.
• SQL Server driver version: 17.

I'm looking for advice on how to reduce the upload time from Access to SQL Server. Any suggestions or insights would be greatly appreciated!
Thanks in advance for your help.

[CJ_London]

Depends on your internet provider but usually upload speeds are significantly slower than download speeds - use one of the many speed checkers on the internet to verify.

so using SSMS is probably downloading.

what if you downloaded from sql server to your access table?

[NoellaG]

Create a txt or csv file with the data in Access and then bulk import into SQL server:
https://www.mssqltips.com/sqlservert...to-sql-server/