can I use DTS wizard with a source and target that is not an SQL table 1

[Rousseau10]

I had the bright idea to bypass access and just use DTS to pull down data from a table. My source is ODBC (relativity data source driver) and my target is excel 2000.

I am using query builder utility which pops up in a dts wizard. I am having trouble with syntax error though.


Is the problem that I am doing something I cannot do to start with or is it likely truly a syntax error??

I was the first American Soldier to put a basketball hoop up in Iraq, only to have it stolen by a soldier from different camp. Newbee - Adam

 

[Luvsql]

Yes, you can use DTS to transfer data from virtually any datasource into any datasource (access to excel, text to access etc).

 

[Rousseau10]

thanks for the confirmation!!!, I though so

I was the first American Soldier to put a basketball hoop up in Iraq, only to have it stolen by a soldier from different camp. Newbee - Adam