I have a query I am wanting to export into some format.
The query has results totaling around 130000 records. I know Excel has a limit of around 65000 rows and 256 colums it can handle, so I was wondering what the best approach would be to export these query results and the method for doing so? Any help would be greatly appreciated!!
If this is a one time thing or you can do it manually each time you need it, just highlight the query, choose File|Save As/Export (might be different in more recent versions) and use the export query to export it to a file. The wizard will allow you to pick a the type of file you want to save it to. It defaults to Access, but you can change it to text. When you choose text it will allow you to pick a Fixed file or a Delimited file. The size of the fields, the delimiter and alot of pther things. Once you get the hang of that, then you can use the TransferText method. Another way you can do it is with a macro. I have found it helpful to set up a macro and get it working then translate it into VBA. When using Transfer Text and TransferDatabase some of the parameters can be a little confusing.