Import Access Data to SQL Express 2005 DB

• pbyrum

  SSCrazy

  Points: 2785

  More actions

  April 23, 2008 at 2:44 pm

  #206421

  Hello,

  I have a SQL Express 2005 database. I have several Excel spreadsheets, all with well defined column headings. I have been using Access 2003 to import the Excel 2003 spreadsheets to Access and then trying to export the data to SQL Express.

  The problems is that Access imports the data to an existing table with errors. It converts a string of numbers to scientific notation.

  Any ideas?

• Vidhya Sagar

  SSCrazy Eights

  Points: 8216

  More actions

  April 25, 2008 at 10:56 pm

  #807485

  [font="Courier New"]Hi,

  Refer the below link...

  http://forums.microsoft.com/forums/ShowPost.aspx?PostID=3240524&SiteID=1

  I hope this will help you!!![/font]

  Regards..Vidhya Sagar
  SQL-Articles