Long text from Access to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hei, I need some help.

I import lots of data from my CRM system into Access and then into excel
because I have more then 100 000 records.

There is one coloumn is like 1000 character (G1). What I do is I make a
query in Access and then I send that result as an email and choose Excel
format. When they recieved that excel sheet Colomne (G1) is much shorter then
1000 character. What should i do so it comes 1000 character in one colomne
in excel?????

Example
A1 602361
B1 GROUPE SEB NORGE (TEFAL KRUPS
C1 3121040008164
D1 12214008
F1 DAMPGENERATOR PRO EXP.5BAR TUR
G1 TEFAL dampgenerator Pro Express Turbo (5 bar) har oppvarmingstid på
kun 2 min og en unik dampytelse, 0-100 g/min. Turbofunksjon: 150 g. Dampen
produseres separat i beholderen og overføres til strykejernet via en egen
slange, noe som gir enkonstant dampproduksjon og heller ingen ventetid ved
påfylling av vann. Vanntanken rommer 700 ml, dampkammeret 300 ml -dette
tilsvarer ca. 90 min. stryking. Toveis strykesåle gjør det enkelt å stryke
både frem og tilbake. Patentert åpent design gir en stabil og sikker
hvileposisjon. Strømledning med automatisk opprulling. Rengjøringstilbehør.


Result in Excel becomes as follow :

A1 602361
B1 GROUPE SEB NORGE (TEFAL KRUPS
C1 3121040008164
D1 12214008
F1 DAMPGENERATOR PRO EXP.5BAR TUR
G1 TEFAL dampgenerator Pro Express Turbo (5 bar) har oppvarmingstid på kun
2 min og en unik dampytelse, 0-100 g/min. Turbofunksjon: 150 g. Dampen
produseres separat i beholderen og overføres til strykejernet via en egen
slange, noe som gir enkonstant damppro

Can anybody help me ? I m using office 2003.

Thanks
Abdul
 
Abdul

If I understand it correctly, the field in Access, which is the source of
the Excel G1 field must be a memo field & that you are using DoCmd.OutputTo
to export from Access to Excel

Whilst you do not say how you are exporting from Access to Excel, this is a
similar issue that I was having recently.

Had to use use an Access query to make a table & then
TransferSpreadsheetmethod e.g.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "<tbName>",
"<PAth>\" & strFileNAme & ".xls", False

where tbName is the table name, Path is Drive & Folder where you want to
have the Excel file placed & strFileName is the name of the Excel file

Hope that helps

Tom
 
Hello Tom

I did make a table out of query for 1 vendour only. Table in Access is good
but then i tried 2 thing to move data from access to excel.

1. Copy from access and past into excel
2. From Access I did Analys data in excel

Both did not work, same problem half of the text does not appear.

Abdul
 
But you didn't use TransferSpreadsheet which does work. You cannot use the
GUI to paste that much text, it must be done programmatically. Using
TransferSpreadsheet, I have successfully filled an Excel cell with over
2,000 characters, twice what your requirement is.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
You can use code from an Access form:

DoCmd.TransferSpreadsheet [transfertype][, spreadsheettype], tablename,
filename[, hasfieldnames][, range]

or use a macro and set the Action to TransferSpreadsheet. If you have no
experience with code, I suggest using the macro which will be self
explanatory.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Hi Arvin

Thanks its working know.

Again thanks a lot.

Abdul

Arvin Meyer said:
You can use code from an Access form:

DoCmd.TransferSpreadsheet [transfertype][, spreadsheettype], tablename,
filename[, hasfieldnames][, range]

or use a macro and set the Action to TransferSpreadsheet. If you have no
experience with code, I suggest using the macro which will be self
explanatory.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

Abdul said:
Hi

How do i do TransferSpreedsheet ? Pls explain.

Abdul
Click to expand...
Click to expand...
 
Back
Top