Search code examples
vb.netimportexportsql-server-2005-express

how to export / import batch of data to SQL Express 2005 in vb.net

I'd like to make a program module that exports all records from three tables in a database into a file at once(I means not adding row by row, maybe like BULK). Here I have some questions

  1. Is it possible to export records of three tables into a file? Or a file per table?
  2. At exporting or importing, I don't want to insert row by row. I wanna do all records at once. Can we do it in programming?
  3. For MS SQL 2005 Express and VS 2005, which data provider should i use?
  4. How about Importing to SQL 2005 Express?
Solution

  • Using bcp to Export / Import

    In exporting to excel file, we can put data from table per sheet. I haven't tested this by using bcp.