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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transferring data from MS Access to MS Excel
try the 'new database query...' in excel under data- import external data you can choose access as the data source -- jerredjohnson ------------------------------------------------------------------------ jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236 View this thread: http://www.excelforum.com/showthread...hreadid=530042 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transferring data from MS Access to MS Excel
Tried that, but this database that I'm trying to import is not in my
local or share drives. It is in some network that I have limited access to. Are there any other ways to tackle this problem? And any idea why selecting text from the field (rather than from inside each cell) should have a character limit in it? Is there anywhere (in Access or in Excel) that I can change this limit? Thanks, Joe. |
Reply |
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) |