Skip to main content
Sign in MENU

Copying Call In Orders Access database over to the new site

MS Info
  • Updated
  1. Create a blank CallInOrderSQL using the MSaleDatabaseUpgrade utility in the MicroSale directory.
  2. Go to the SQL Management Studio and right-click on the call in ordersSQL database then go to tasks > import data.
  3. Choose Data Source -> Select MicroSoft Access, then browse to the folder where you have the Call In Orders Access Database stored. Next
  4. Choose a Destination -> Make sure this is using SQL Server Native Client, make sure the database is Call In OrdersSQL, Next.
  5. Make sure you Copy Data from one or more tables or views, next
  6. Make sure to select all of the Tables and Views, Next.
  7. Run Immediately, Next.
  8. Finish once the conversion has completed.