Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
accessing outputs of Sybase stored Porcedure via ODBC in Access
- Thread starter storage
- Start date
If you have the result of that stored procedure dumped to a table, you can do this. Go to your Start menu, Settings and start Control Panel. From there, choose the ODBC Connections function. Create an ODBC connection to your Sybase table.
Open Access and create a new database or use an existing database. Go to your File Menu, Get External Data and either link to that table to make changes in the Sybase table or Import if you want to pull the data into an Access table.
That should do it...
HTH
Terry M. Hoey
th3856@txmail.sbc.com
Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?
Open Access and create a new database or use an existing database. Go to your File Menu, Get External Data and either link to that table to make changes in the Sybase table or Import if you want to pull the data into an Access table.
That should do it...
HTH
Terry M. Hoey
th3856@txmail.sbc.com
Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?
- Status
Similar threads
- Locked
- Question
- Locked
- Question
