Export Import

• ibrani

  Newbie

  Points: 1

  More actions

  August 11, 2005 at 4:04 am

  #88439

  Hi, need help plz.

  first i have a bad english so plz, i'm sorry 4 ur Inconvenient

  i've try to export/import data via BCP to access file format.

  my problem : i can't export more then 1 table at the same time

  i try to exec xp_Cmdsheell 'bcp .... ' for each table ( few table ) and i found another problem, i can't export few tables into 1 file

  for example i try to export table A,B,C to c:\test.mdb

  thx 4 ur attention. and also ur opinion. thx

• Vasc

  SSCarpal Tunnel

  Points: 4643

  More actions

  August 11, 2005 at 9:31 am

  #581444

  sp_addlinkedserver  might help you

  ---

  Kindest Regards,

  Vasc