If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
MSAccess query conversion to excel
I have a MSAccess query which contains some memo fields. I am using Office
links to transfer the data to Excel. There are about 500 characters in some of the memo fields. All the data is displayed as expected in the query, but when the data is transferred to Excel the data in the memo field cells is cut off. Is there a way to make sure all data from a memo field is transferred to Excel? ( I would be happy with a limit of even 1000 characters) Any help greatly appreciated John Baker |
#2
|
|||
|
|||
MSAccess query conversion to excel
In Access, use the TransferSpreadsheet method to send the data, and
specify one of the later Excel versions. You can do this by creating a macro, or writing some code, e.g.: '====================== Sub SendTableToExcel() DoCmd.TransferSpreadsheet acExport, _ acSpreadsheetTypeExcel9, "tblCustomers", _ "c:\Data\MyExcelFile.xls", True End Sub '=========================== Then, add a button on a form, to run the macro or the code. John Baker wrote: I have a MSAccess query which contains some memo fields. I am using Office links to transfer the data to Excel. There are about 500 characters in some of the memo fields. All the data is displayed as expected in the query, but when the data is transferred to Excel the data in the memo field cells is cut off. Is there a way to make sure all data from a memo field is transferred to Excel? ( I would be happy with a limit of even 1000 characters) Any help greatly appreciated -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Query error | Patti | General Discussion | 4 | August 10th, 2004 07:58 PM |
Linking an Excel worksheet to an Access table | Sitara Lal | General Discussions | 6 | August 9th, 2004 10:13 PM |
Linking an Excel worksheet to an Access table | Ken Snell | General Discussion | 5 | August 9th, 2004 10:13 PM |
Struggling with MS Query... | Alex | General Discussion | 5 | July 6th, 2004 11:46 AM |
Add-in functions when starting Excel programmatically | Steve K. | Worksheet Functions | 11 | July 2nd, 2004 06:38 PM |