How does Data=Import External Data = Import Data
allow for easy updating over just opening the file in Excel (which
apparently does what you want).

I have never seen creating a query table as a two way link? Is that an
option?

--
Regards,
Tom Ogilvy

"Joe HM" wrote in message
oups.com...
Hello -

I need to load data from a CSV file that contains line-breaks in some
entries. The file looks like

"DATA-A", "A"
"DATA-B", "B
C
D"
"DATA-E", "E"

when I open it in an ASCII editor. The line-breaks are Chr(10) and if
I open the file in Excel it puts the B C D in one cell with three
lines.

My problem is that I want to load this data with the Data Import
External Data Import Data... function so that I can easily update it.
I tried that but Excel will interpret the Chr(10) as a new line and
the imported data will look like it does in the ASCII editor.

I guess I could write some VB code and link that to a button to do the
loading and correct interpretation of that data, but I think it would
be easier to just use Excel's existing functionality if it lets me do
that.

I would appreciate any suggestions!

Thanks,
Joe