Import data from Fox Pro database into SQL 2000

[Dave Navarro]

One of my clients is a realtor. The MLS system used by his local board
is a fox pro application. I have been able to successfully access the
MLS data from the fox pro application using ODBC, but it's a bit slow
(as you can expect).

I'd like to import the data from the fox database into an SQL 2000
database where I can do more with it on the clients web site. The fox
database is updated hourly.

My question is... Is there an automated way to get SQL to import
records from an external database? I'm already using the "AT" command
to run daily events on the server. Can I access ODBC and SQL from a
..VBS script and add that to my events?

Thanks for any insight anyone can provide.

--Dave

[Dave Navarro]

In article <O#tqFA2VDHA.1896@TK2MSFTNGP12.phx.gbl>, [email]reb_01501@yahoo.com[/email]
says...

> You can create a SQL DTS (Data Transformation Services) package (There's a
> wizard you can use) to import the records from your Foxpro database, and use
> SQL Agent to schedule it. See Books Online (BOL). A good website is
> [url]www.sqldts.com[/url].

Many thanks Bob! I'll check it out.

--Dave