need mulitple lines in a cell

S

shakaree

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
 
S

Sean Timmons

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...
 
S

shakaree

Thanks for the response, this does not get the 3 pieces of data into a single
cell. I already have the data separated and can put it all together in one
cell but not with end of line indicators so access sees an enter and places
the second piece of data on a separate line within the same field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

De-concatenate but maintain relationship/record structure 3
Need Help Editing Cells 7
convert Excel data to Access 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
One for JMB, DE-concatenating, but keeping relationship 6
Mulitple text lines in a single cell 2
Error 0x800A03EC when trying to populate a worksheet 3
Importing text file without end-of-line delimiter? 8

Top