Exporting into Excel / Text getting 'chopped off'

[CherylH]

Hi! If anyone can help me with this issue it would be most appreciated! I
am exporting a table, from MS Access into Excel, and within a description
column some of the text is being chopped off (essentially, not the entire
description is moving over). I've tried to use the "Export" command in
Access, and have also tried to just copy and paste the table....same results.
The table only has 75 rows of data.

Thanks in advance!
Cheryl

 

[Dale Fye]

Cheryl,

Cannot remember the exact number of characters (think it is 1024) that
Access will push to Excel when you do an export of a table or query. There
are several ways around this. I'll describe the process in 2007. It is
similar, but not exactly the same in 2003.

1. Open Excel to a new workbook.
2. On the data tab, there is an option Get External Data (from Access).
Click that.
3. Select the database containing your table.
4. Click OK on the Data Link Properties dialog
5. Select the table or query you want to use.
6. Tell it where you want to put the data in your spreadsheet.

That's it.

If you want to keep your links, do that and updates in the database will be
reflected in the spreadsheet whenever you refresh the link (either the Data
or Design tab). If you want to sever the links, go to the data tab, select
Connections, highlight the database that you were connected to, and click
remove.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[Ken Snell \(MVP\)]

If you're exporting the data using the File | Export menu process in ACCESS,
all text longer than 255 characters will be truncated. This is because this
export process uses the EXCEL 95 format.

Use the TransferSpreadsheet action in a macro or in VBA code to do the
export; no truncation occurs using this method. This method uses
EXCEL97-2003 format.

 

[Dale Fye]

Thanks, Ken.

I'll have to give that a try.

Dale