transferdatabase data returned by stored procedure -
08-06-2003
, 03:46 AM
Hello all,
I have some problem i can't handle. I work on adp project connected to sql
server 2000. When i try to run command:
DoCmd.TransferDatabase acExport, "dBase IV", "C:\", acStoredProcedure,
"sp_Invoices", "C:\Invoices.dbf", False
or
DoCmd.TransferDatabase acExport, "dBase IV", "C:\", acServerView,
"v_Invoices", "C:\Invoices.dbf", False
i recive a message Can't find object v_Invoices.
But command
DoCmd.TransferDatabase acExport, "dBase IV", "C:\", acTable, "t_Invoices",
"C:\Invoices.dbf", False
works fine.
Anyone have idea what i can do to transfer data returned by stored procedure
or view to dBase database ?
Thanks for help,
Luke |