Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003

    Question Unanswered: 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.



  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    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.

    blindman "sqlblindman"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts