Post reply

import Excel spread sheet as table

  • August 12, 2009 at 4:47 pm

    #209448

    I converted an Access table to an Excel spread sheet. One of the fields was a memo field in Access. Is there any way to get either the original Access table or the Excel spread sheet into SQL Server?

  • August 12, 2009 at 5:34 pm

    #1038393

    No but Access memo can use SQL Server 2005/8 Varchar/NvarChar(Max) without any issues because Memo was imported into SQL Server 2000 Text/NText columns.

    Kind regards,
    Gift Peddie

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply