Garren.Shannon
Member
- Local time
- Yesterday, 16:55
- Joined
- Sep 22, 2022
- Messages
- 113
Hey all,
Again, thanks to all who reply. This forum is great for nubies like me. I only have a tacit understanding of SQL server operations and I do have a working knowledge of SQL commands.
I most likely didn't do this correctly but I do have a backup. I have a fairly simply Access DB I crafted to track school bus ridership logs for reporting and getting funding from the state. I had trouble using the SQL Server Migration Assistant for Access tool so I tried going the "Split Database" with the "SQL 2019 Import and Export Data" tools. I now have tables in SQL but the original DB now looks for the tables in the link file... be.accdb. I used the be.accdb file to import the tables into SQL.
How do I tell the program to look for each table in our SQL server rather than the local link file? Or am I going down the complete wrong path here?
Again, thanks to all who reply. This forum is great for nubies like me. I only have a tacit understanding of SQL server operations and I do have a working knowledge of SQL commands.
I most likely didn't do this correctly but I do have a backup. I have a fairly simply Access DB I crafted to track school bus ridership logs for reporting and getting funding from the state. I had trouble using the SQL Server Migration Assistant for Access tool so I tried going the "Split Database" with the "SQL 2019 Import and Export Data" tools. I now have tables in SQL but the original DB now looks for the tables in the link file... be.accdb. I used the be.accdb file to import the tables into SQL.
How do I tell the program to look for each table in our SQL server rather than the local link file? Or am I going down the complete wrong path here?