If you want the data in Access to show down a single field, I'd suggest
making the change in Excel first.

Got to Data - Text to columns, pick comma to break it up, then highlight the
data, go to a blank cell, paste special transpose...



"shakaree" wrote:

I am putting together data to be imported into MSACCESS. In one field in
ACCESS you can have multiple lines, but in excel they show up in one cell.

How can I enter data into excel but in the access field show mulitple lines

data is as such
Dodge, Charger, 2007
in Access when displayed as
Dodge
Charger
2007

I hope this is clear