Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transferring data from MS Access to MS Excel
Hi,
I have a very big Access database that I am trying to copy onto MS Excel for analysis. However, when I try to export this data using the "Analyze using Excel" function, or by copying all fields and pasting it onto Excel, I find that some of the longer text entries (eg: Claim details) get truncated. Interestingly, if I go INTO that particular cell entry, select the text in the cell, copy and paste it into an Excel cell, it does not get truncated at all. Can someone please help me with this? I would like to know: 1. Why this is happening 2. A possible way in which I can move all the data into Excel I tried the "export" function, but this data is read-only, so that function doesnt work. Thanks in advance, Joe. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Large Access Table into Excel | Links and Linking in Excel | |||
Data from Excel to Access Table | Excel Discussion (Misc queries) | |||
How to import data from a password protected Access DB into Excel. | Excel Discussion (Misc queries) | |||
Data Access Pages - Excel 2003 | Excel Discussion (Misc queries) | |||
data transfer from Excel to Access but the new table stru is diff | Excel Discussion (Misc queries) |