Convert from WrapText
 

Stuart wrote:
[b]I have data in col B (set to width of 55) and Wraptext is enabled
in just this col. In all, each record occupies up to 15 columns.

I wish to import this data into Access (working with Office 2000),
and have found a routine to do this. However, it seems that only
using VBA or converting the file to CSV format will allow the
Access record to occupy more than one row? I believe that to be
correct.

In Excel, if I could 'split' the wrapped cells into a series o
rows,
and paste data accordingly, then I might end up with 3 row
containing
the original cell value. If I then import this, then as best I ca
guess,
Access would treat each of these rows as a recordset when imported,
even though they are really part of one Excel record.

I need all the colB data to display in Access, since it contains the
crucial information that allows the user to modify the information
held in the related fields.

Not sure how to proceed, so would be grateful for suggestions.

Regards.



I presume you have already tried using "memo" in Access instead o
"Text" for the field type?

Scoobydeu


-
scoobydeu
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message581804.htm