Migrating a Microsoft Office Access database to Microsoft SQL Server?

Question

Database migration

There is a table in Access, it has 4 fields: Record number, name, date, old name.
There is a table in SQL Studio, it has records, each record has a table, let's call it test, which contains 2 fields: Date and old name .
I need to unload all the data from Access into SQL in the test table by the record number.
Tell me where should I "dig"? I saw something similar in Google, but it was only from sql to access, but it does not suit me.
I googled this strletzcoder.ru/perenos-bazyi-dannyih-microsoft-o...
At the end, the author of the article writes:

Also, even if you only export tables, there are a lot of extra steps to be taken after the export (re-creating links, etc.). Therefore, the described method of transferring databases from Access to MS SQL is practically no longer used.
Instead, it is strongly recommended to use either the built-in "Convert to SQL Server Format Wizard" or import the Access database from the MS SQL side using its tools.

Has anyone already hosted these events?

Answer 1

If the operation is one-time, then you can upload the file to the new\existing database through the data import-export wizard. Solved with just a couple of clicks. Periodically, once a month, I upload the data I need so much.
If the data needs to be pulled constantly, then you can either use open query, or automate the deployment of the database using scripts