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 of rows,
and paste data accordingly, then I might end up with 3 rows containing
the original cell value. If I then import this, then as best I can 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.





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.659 / Virus Database: 423 - Release Date: 15/04/2004