Exporting Access to MS SQL

[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

 

[Ed]

I'd start by using the upsizing wizard. If your database is relatively
simple and straight forward it will do a pretty good job.

 

[Mary Chipman]

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

 

[new one]

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