load csv files directly or first into Access

• cmato

  Grasshopper

  Points: 13

  More actions

  April 21, 2004 at 2:15 pm

  #84174

  Is there any benefit to loading csv formatted data into sql 2000 from Access as opposed to just loading the text files into sql?

• SteveB-74825

  Hall of Fame

  Points: 3290

  More actions

  April 22, 2004 at 8:56 am

  #503855

  no - i would just import them straight into your database.

  (right click on database > ALl Tasks > Import Data > set datasource to text file)

  cheers

  dbgeezer