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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting sybase stored procedure output into access table ?

Status
Not open for further replies.

prasadmokashi

Programmer
Oct 31, 2003
41
US
Hi,

I am running sybase stored procedure using pass-through query.
I want to get the output of this stored procedure into one table in my access database.

I tried OutputTo excel and then TransferSpreadsheet to table.

But as procedure output is more no of records ( > 30000) , it gives error while sending query output to excel, because of excel max no. of rows limitation.

Is there any other way of achieving what I want ?

Thanks,
Prasad

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top