How to import DATA from SQL2K to Access?

M

Mehbs

I am using get external data, import, ODBC type and it's error out saying I
cannot use ODBC to import/export data.

I would appreciate if someone please show me the better way of importing
data from sql.
 
M

M.L. Sco Scofield

Mehbs,

Two ways.

1 - From SQL Server, use DTS to copy the data from the SQL Server table to
the Access table.

2 - From Access, link your SQL Server table through ODBC and then use an
append query to copy the data from the linked SQL Server table to your
Access table.

Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, A+, Access MVP 2001 - 2005
Denver Area Access Users Group Past President 2006/2007 www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
This email made with 100% recycled electrons!
Miscellaneous Access "stuff" at www.ScoBiz.com
 
G

gus

I think you all should try to figure it out as a group
message
Hello,

Take a look at dbconvert.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to import only a few fields from an external table 4
Link tables from ODBC database 1
ODBC Import 1
Import/Export 7
Import Of data to table 3
ODBC window doesn't appear when wanting to import data 1
trying to import data from excel 4
Export an Access table to an EXISTING Oracle Table 1

Top