Search results

Thanks for the pointer Bob The Access specification ( for Access Projects) for table columns is actually 1024. So the problem seems to be only with the DoCmd.TransferSpreadsheet method Thanks Claude

Thanks once again Bob. Can you direct me to the Access specs for the number of fields. I tried looking for them but did not find the limit for the number of fields. This will help remove the skeptical look from the client's eyes Claude

Thanks Bob but I can't upload the table. But believe me the query with over 430 columns runs fine in Access. Perhaps you can give this as an exercise to somebody. Create a normal query and then keep repeating the fields in the output fields. There is no problems because Access will give Aliases...

Surprising as it may sound I am referring to columns and not rows. And this is a real life situation for a client who is dealing in retirement plans. After running the query the access table does get created with all the fields but it is only when exporting to Excel that the spreadsheet had...

Thanks Bob, Yes the access table does have 440 fields. I did not create the table manually but by selecting into a table from a query. Claude

I used the DoCmd.TransferSpreadsheet method to export from an Access 2003 table to Excel. The table had around 440 fields but only 230 (column iv) got exported. Does anybody know whether there is a limitation on the number of fields that can be exported. Thanks Claude

Could not access the links - 403 access denied on apache server Hi I was trying to access the links that you suggested but access was refused. I would like to know how to find a particular folder in the respective "My documnets" folder for the current user. The application objects Filesearch...

Thanks a lot guys DoCmd.TransferSpreadsheet does more but DoCmd.OutPutTo offers a better user experience - allows you to choose the location of the file and also opens Excel with the exported file. Can we do the same with DoCmd.TransferSpreadsheet? Thanks claude

Hi all, I have been using this command in VB to export Access tables to Excel. Everything works fine except when the table contains a large Character/Text field- it gets truncated to around 200 chars. Is this a known limitation or I am doing something wrong? DoCmd.TransferSpreadsheet command...