Exporting Access to MS SQL

  • Thread starter Thread starter new one
  • Start date Start date
N

new one

i am very new to this and need help :) i am sure this is
doable, i just can't find good documentation about it.

I have a small DB in Access with some queries and macros
that I would like to upgrade to MS SQL. I know how to
import the data, but here are my other questions
1) can I save the queries somehow and have them accesable
by MSSQL
2) what about macros and a module?

thanks,
branka
 
I'd start by using the upsizing wizard. If your database is relatively
simple and straight forward it will do a pretty good job.
 
SQL Server is solely a relational database, and has no UI features
like macros or modules. You'd be well advised to get a good
introductory book on SQL Server before you get in over your head --
there's lots of them out there, just do a search on amazon.com. The
learning curve is much higher than it is in Access.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446
 
I just tried that and got bunch of usless errors "error
exporting the table" for every one of my tables... i know
i can import the tables fine from SQL directly.

thanks,
branka
 
Back
Top