-----Original Message-----
Is it possible to move the data from a SQL database into a
new database on Access 2003?
Yolanda,
At least two ways to do this. Both require you to have
some sort of authorization to hit the SQL box. If you
can't read the data (say in a linked table in an Access
file) then you'd need to contact the SQL admin and request
they set you up.
1) from Access: if you have your ODBC driver set up so you
can link to the SQL Server tables from within Access, then
you can create a MakeTable query that pulls the data from
the linked SQL table and appends it into a new table
within Access itself.
Just start with a regular Select query, pull in all the
fields you want to go into Access, then from the query
design grid choose Query/Make-table query from the menu.
You will get a dialog box asking you for the name of the
table to create. Type in a meaningful name, then click OK
and run the query (the red exclamation button on your
toolbar). You should get a message saying the table was
created successfully. Then you can use that table as you
would any other table in Access.
2) from SQL Server: go to Enterprise Manager. Choose
Tools/Data Transformation Service/Export Data from teh
menu. You'll get a wizard that guides you through the
process of moving data from one place to another (SQL to
Access is just one of many possible combinations).
The details of DTS are outside the scope of this
newsgroup, but that'll get you started.
Again, if you don't currently have access to the SQL
Server data itself then you need to ask the SQL admin or
DBA to grant you permission to read the tables.
HTH,
Terrell
