Exporting Structure & Data to Access Table

Hello E'body

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.
Its urgent.

Bye.

LaxI 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.

Exporting SQL Server Data

Hi,
We are migrating our website to a new hosting site. The site has a
CMS written in C# with a SQL Server backend. I need to migrate this
but the new hosting site will not allow me to restore the SQL Server
from backup at the new site and requires that I import CSV files.
How can I export the data to a CSV to import at the new hosting site?
Thank you very much.Hi
How about http://www.sqldts.com/299.aspx or you could use BCP and generate
the commands from sysobjects.
John
"KDawg44" <KDawg44@.gmail.com> wrote in message
news:74fd81da-6361-4544-aece-0330377841ce@.z38g2000hsc.googlegroups.com...
> Hi,
> We are migrating our website to a new hosting site. The site has a
> CMS written in C# with a SQL Server backend. I need to migrate this
> but the new hosting site will not allow me to restore the SQL Server
> from backup at the new site and requires that I import CSV files.
> How can I export the data to a CSV to import at the new hosting site?
> Thank you very much.