Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • Last Modified:

Move Access 97 file to SQL server

Any one can tell me how to move an Access file to SQL server? Is any plug in to do that? I heard of the "Upsizing Wizard" in Access 97, but it is not working for me even I went through the documentation in Microsoft's page. Anyone can give me a step by step procedures for it?
0
joeng
Asked:
joeng
1 Solution
 
JiaHCommented:
You can use the saveas/export function (manual) under the file menu or use the TransferDatabase to do (code) it. Use ODBC to create a DSN for the SQL.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now