jottiwell
Nov 9th, 2000, 06:57 AM
Hello,
In my earlier post I was asking for ways to update the list of tables shown in the database window of an Access .adp file linked to an SQL backend. The main reason for wanting to know this is so I can use the docmd.transfertext function from Access, to transfer the contents of a table created by a storedproc, to a text file. I'm running into walls all the time, therefore has anybody any idea how to do the following.
In Access, call a stored procedure which accepts parameters taken from a field on a form, then transfer the output of that stored procedure to a .csv file.
I don't mind how this is done, I'm currently working on pushing the data to temporary tables, then reading the data out of the temp tables and transferring it with the docmd.transfertext function but it's all going horribly wrong.
Any help ( suggestions of methods anything ) would be greatly appreciated,
Thanks
John
In my earlier post I was asking for ways to update the list of tables shown in the database window of an Access .adp file linked to an SQL backend. The main reason for wanting to know this is so I can use the docmd.transfertext function from Access, to transfer the contents of a table created by a storedproc, to a text file. I'm running into walls all the time, therefore has anybody any idea how to do the following.
In Access, call a stored procedure which accepts parameters taken from a field on a form, then transfer the output of that stored procedure to a .csv file.
I don't mind how this is done, I'm currently working on pushing the data to temporary tables, then reading the data out of the temp tables and transferring it with the docmd.transfertext function but it's all going horribly wrong.
Any help ( suggestions of methods anything ) would be greatly appreciated,
Thanks
John