Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting from Access to Excel
solution:
write your own routine using ADO examples on www.erlandsendata.no keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool ?B?RGFu?= wrote: Hi! I am using the TransferSpreadsheet function (in Access) to export an Access (2003) table to an Excel spreadsheet. The problem is fields that have more than 255 characters are being truncated to 255 in the new Excel sheet it created. Any ideas on how to get around this issue? Thanks a lot for any help! Dan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting from Access to Excel
keepITcool wrote ...
write your own routine using ADO Something less drastic would be to try and do the export using a query in the MS Access UI e.g. the following result in no truncation in Access2003: To create a new Excel table (workbook and/or range will be automatically created): SELECT MyMemoCol INTO [Excel 8.0;Database=C:\TotallyNew.xls;].MyNewTable FROM MyTable ; To create a new Excel table: INSERT INTO [Excel 8.0;Database=C:\TotallyNew.xls;].MyExisingTable (MyExcelColumn) SELECT MyMemoCol FROM MyTable ; Jamie. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
exporting data from access to excel | Excel Discussion (Misc queries) | |||
Exporting data from access to excel | Excel Worksheet Functions | |||
Exporting an Excel Chart into Access | Charts and Charting in Excel | |||
Exporting fields from access to excel | Excel Discussion (Misc queries) | |||
Exporting Excel to Access | Excel Programming |