Skip to main content
How to Migrate House Accounts/Gift Cards to SQL
- Create a blank House Accounts SQL database using the MSaleDatabaseUpgrade utility in the MicroSale directory.
- Go to the SQL Management Studio and right-click on the House Accounts database then go to tasks > import data.
- Choose Data Source -> Select MicroSoft Access, then browse to the folder where you have the Scan Access Database stored. Next
- Choose a Destination -> Make sure this is using SQL Server Native Client, make sure the database is House Accounts, Next.
- Make sure you Copy Data from one or more tables or views, next
- Make sure to select all of the Tables and Views, Next.
- Run Immediately, Next.
- Finish once the conversion has completed.