How can I import excel file same as excel data. Ken 10.08.2006 15:28:01 Carriage return (Alt+del) in excel data in one cell is imported to small aquare box into the place of carriage return. Some one have magic idea to import same as excel? Excal source data I hope this work A) It should work this way After import to Access I hope this work â–¡ A) It should work this way

RE: How can I import excel file same as excel data. jmonty 10.08.2006 15:40:02 Is the field you are importing to a Text field? Maybe you should try changing it to a Memo field instead. jmonty "Ken" wrote: [Quoted Text] > Carriage return (Alt+del) in excel data in one cell is imported to small > aquare box into the place of carriage return. Some one have magic idea to > import same as excel? > > Excal source data > I hope this work > A) It should work this way > > After import to Access > I hope this work â–¡ A) It should work this way

Correction Typo: How can I import excel file same as excel data. Ken 10.08.2006 15:41:02 Carriage return (Alt+Return) in excel data in one cell is imported to small square box into the place of carriage return. Some one have magic idea to import same as excel? Excal source data I hope this work A) It should work this way After import to Access I hope this work â–¡ A) It should work this way

RE: How can I import excel file same as excel data. Ken 10.08.2006 15:46:02 Thank you for your message, but does not work for my case. "jmonty" wrote: [Quoted Text] > Is the field you are importing to a Text field? > Maybe you should try changing it to a Memo field instead. > > jmonty > > > "Ken" wrote: > > > Carriage return (Alt+del) in excel data in one cell is imported to small > > aquare box into the place of carriage return. Some one have magic idea to > > import same as excel? > > > > Excal source data > > I hope this work > > A) It should work this way > > > > After import to Access > > I hope this work â–¡ A) It should work this way

Re: How can I import excel file same as excel data. John Nurick <j.mapSoN.nurick[ at ]dial.pipex.com> 10.08.2006 20:12:25 Hi Ken, Excel uses the LF (linefeed) character - Chr(10) - to indicate a newline within a cell. Access requires the standard Windows newline, the two characters CR and LF - Chr(13) & Chr(10). Usually the simplest thing to do is to import the data as is, and then use an update query to make the changes. If the field name is XXX, update it to Replace([XXX], Chr(10), Chr(13) & Chr(10)) That will work in Access 2002 and later; post back here if you are using an earlier version. On Thu, 10 Aug 2006 08:28:01 -0700, Ken <Ken[ at ]discussions.microsoft.com> wrote: [Quoted Text] >Carriage return (Alt+del) in excel data in one cell is imported to small >aquare box into the place of carriage return. Some one have magic idea to >import same as excel? > >Excal source data >I hope this work >A) It should work this way > >After import to Access >I hope this work ? A) It should work this way -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email.

Re: How can I import excel file same as excel data. Ken 10.08.2006 20:51:01 Thank you for your help, John. "John Nurick" wrote: [Quoted Text] > Hi Ken, > > Excel uses the LF (linefeed) character - Chr(10) - to indicate a newline > within a cell. Access requires the standard Windows newline, the two > characters CR and LF - Chr(13) & Chr(10). > > Usually the simplest thing to do is to import the data as is, and then > use an update query to make the changes. If the field name is XXX, > update it to > Replace([XXX], Chr(10), Chr(13) & Chr(10)) > > That will work in Access 2002 and later; post back here if you are using > an earlier version. > > On Thu, 10 Aug 2006 08:28:01 -0700, Ken <Ken[ at ]discussions.microsoft.com> > wrote: > > >Carriage return (Alt+del) in excel data in one cell is imported to small > >aquare box into the place of carriage return. Some one have magic idea to > >import same as excel? > > > >Excal source data > >I hope this work > >A) It should work this way > > > >After import to Access > >I hope this work ? A) It should work this way > > -- > John Nurick [Microsoft Access MVP] > > Please respond in the newgroup and not by email. >