J Jackie Sep 9, 2003 #1 How do you import an Excel spreadsheet with hard returns into an Access table and retain the hard returns?
How do you import an Excel spreadsheet with hard returns into an Access table and retain the hard returns?
T Terry Sep 10, 2003 #2 Jackie, This question would be better in the externaldata group. Anyway if you save you spreadsheet as a txt file (tab delimited is fine) and import the text file into access the hard returns are maintained. HTH Terry
Jackie, This question would be better in the externaldata group. Anyway if you save you spreadsheet as a txt file (tab delimited is fine) and import the text file into access the hard returns are maintained. HTH Terry