Heres a good one!
Access 2003 / Excel 2003
I have an access database with a table which is the source for a new database query in excel. The access table has 29 columns and the Excel query in the query view has the same 29 columns. Two of the columns always have NULL data (i.e. they are empty) - this is preserve CSV file layouts (I know.. I know..)
When I return the query results to the spreadsheet, the two columns have been dropped and I only have 27 columns. I can't find anything about this on the web, has anyone else experienced anything similar?
Obiron
Access 2003 / Excel 2003
I have an access database with a table which is the source for a new database query in excel. The access table has 29 columns and the Excel query in the query view has the same 29 columns. Two of the columns always have NULL data (i.e. they are empty) - this is preserve CSV file layouts (I know.. I know..)
When I return the query results to the spreadsheet, the two columns have been dropped and I only have 27 columns. I can't find anything about this on the web, has anyone else experienced anything similar?
Obiron