Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with Linking table and end of line character

Status
Not open for further replies.

asanchez4

Programmer
Apr 22, 2004
32
0
0
US
I have a problem linking a table with an excel spreadsheet. The field in the spreadsheet is General format and contains several lines of text. When I link to the spreadsheet and look at the data in Access, wherever there is a new line in Excel there is a square box character.

For instance, in Excel it says...

This is line 1

This is line 2

When I look at the field in Access it says...
"This is line 1[]This is line 2[]"

Any ideas?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top