Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need mulitple lines in a cell
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
need mulitple lines in a cell
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
need mulitple lines in a cell
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. "Sean Timmons" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mulitple text lines in a single cell | New Users to Excel | |||
inserted lines move how to place lines in proper cell? | Excel Worksheet Functions | |||
Mulitple Formulas/Same Cell | Excel Worksheet Functions | |||
Copy selected mulitple worksheets to mulitple new workbooks | Excel Programming | |||
Copy selected mulitple worksheets to mulitple new workbooks | Excel Programming |