Imported data from Access is cutting off in SQL

[JPMorgan]

I have imported a table from Access into SQL 7 and the memo fields are cut off. I have tried renaming the datatypes in SQL and re-importing the data and still not working. Still cutting off memo fields.

Any ideas?

 

[RickCole]

Are your memo fields being imported to text datatype fields in your SQL Server table??

Rick

 

[JPMorgan]

Yes, At first I tried to import the Access table into a new SQL. The comments were cut off. Then I changed the datatype to text in SQL and tried to import the same access file into the table that I had previously created, deleteing the data an apending the new stuff. This didn't work either.

I even tried to cut and paste the comment itself right into the SQL field and it stored that wonderful <Long Text> in the field. I ran a SELECT query in Query Analyzer and it stil came up as <Long Text>.

 

[RickCole]

I've not done much on importing Access tables so not sure why you’re hitting this problem.

As a work around why don't you link the Access database to your SQL Server. Then use Query analyser to get to the Access data and insert or update onto the SQL Server table.

Sorry I can't offer much else on this one.

Rick.

 

[henan]

I am facing the same problem. Have you sorted it out? Could you tell how you sort it out ?

 

[JPMorgan]

Havn't figured it out yet, but will certainly reveal the mistery when I do.