Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Query Cell Limit
I am importing data from an Access DB using a MS query. All work perfectly
apart from the memo fields which contain more the 255 characters of data. ONly the first 255 characters are imported onto my Excel 2003 worksheet. Is there any way to import the full contents of a meno field into Excel using a MS query? Paul Smith |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Query Cell Limit
I don't speak the Access, but Debra Dalgleish once posted this:
Or, transfer the data with code. Use the TransferSpreadsheet method to send the data, and specify one of the later Excel versions: '====================== Sub SendTableToExcel() DoCmd.TransferSpreadsheet acExport, _ acSpreadsheetTypeExcel9, "tblCustomers", _ "c:\Data\ExcelExport.xls", True End Sub '=========================== http://groups.google.co.uk/group/mic...cbe18fd9d6d82b or http://snipurl.com/1a01v Paul W Smith wrote: I am importing data from an Access DB using a MS query. All work perfectly apart from the memo fields which contain more the 255 characters of data. ONly the first 255 characters are imported onto my Excel 2003 worksheet. Is there any way to import the full contents of a meno field into Excel using a MS query? Paul Smith -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Query Cell Limit
I asked the question in the Excel programming group because I am controlling
the operation from Excel. I am hoping to get an answer from an Excel programming perspective. I have no idea how to use the code below from Excel. Basically I use MS query to import data and fields come through trncated at 255 chars. can anyone offer any Excel related advice? PWS "Dave Peterson" wrote in message ... I don't speak the Access, but Debra Dalgleish once posted this: Or, transfer the data with code. Use the TransferSpreadsheet method to send the data, and specify one of the later Excel versions: '====================== Sub SendTableToExcel() DoCmd.TransferSpreadsheet acExport, _ acSpreadsheetTypeExcel9, "tblCustomers", _ "c:\Data\ExcelExport.xls", True End Sub '=========================== http://groups.google.co.uk/group/mic...cbe18fd9d6d82b or http://snipurl.com/1a01v Paul W Smith wrote: I am importing data from an Access DB using a MS query. All work perfectly apart from the memo fields which contain more the 255 characters of data. ONly the first 255 characters are imported onto my Excel 2003 worksheet. Is there any way to import the full contents of a meno field into Excel using a MS query? Paul Smith -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
limit records in query | Excel Discussion (Misc queries) | |||
Size Limit for ADO query? | Excel Programming | |||
Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) | |||
How do I limit the rows returned into Excel from a query | Excel Programming | |||
MS Query Limit results | Excel Programming |