excel comma separate file with comma in the cell import to MS ACCESS

• Frances L

  SSCarpal Tunnel

  Points: 4727

  More actions

  March 16, 2009 at 12:43 pm

  #71399

  In the MS office Excel comma separated value file, the data shows properly, but when I try to export the csv file into excel. if the data has comma in the excel cell, it will separate the data.

  Smith, HowardColumbus NE68601

  but when I imported into MS ACCESS, it same out as Smith HowardColumbus NE 68601 Five column in instead .

  Thanks.

• Chris Quinn-821458

  Hall of Fame

  Points: 3192

  More actions

  March 17, 2009 at 10:29 am

  #961222

  When you import the file, make sure that the text specifier is set to " (double quote) in the second screen of the Import Text wizard.

  If you want to do this regularly, click on the Advanced button and create an import specification

• Frances L

  SSCarpal Tunnel

  Points: 4727

  More actions

  March 17, 2009 at 11:10 am

  #961244

  I set that as link table right now. It should solve the problem.Thx.