Unanswered: Exporting Structure & Data to Access Table
I have an application with MSAccess as front end and SQLServer as backend. have quite a bit of tables. i wanted to write a stored procedure which exports a SQL Server table (both Structure & Data) to a new Access MDB file. i know with the use of DTS its possible but i need to code it down. i need to perform this at runtime. so can anybody help.
I don't think you can write a stored procedure to do this. You may be able to write an Access module that will do it, but it won't be easy because Access.mdb datatypes do not match SQL Server datatypes.
If it's not practically useful, then it's practically useless.