Spreadsheets

[aziz rasul]

I have a table which contains information in which part of it is correct and part of it is incorrect.

My remit is that I have to produce an Excel spreadsheet with ALL the data but that the cell values containing the incorrect values must appear in a different font colour or some other formatting feature that shows clearly where the incorrect information is on the spreadsheet e.g. using highlight feature, font, font weight, etc.

The table will also contain about 1 million records. Am I right in saying that Excel spreadsheets cannot hold this many records and that there is a lower limit?

 

[CJBIRKIN]

Hi

Yes there is a limit of ~64000 rows of data in an individual sheet.

Ps there is an excel board for excel queries

Chris

 

[aziz rasul]

Thanks for the 64k.

I've noted your comment about the Excel board. However this is still an Access problem since I'm hoping to use Automation.

 

[Rich]

You can of course produce a report within Access that looks like a spreadsheet

 

[aziz rasul]

Unfortunately the powers to be want it as a spreadsheet. I have no control over this.

 

[MattS]

Is it whole records that are incorrect, or just particular fields? And how do you identify the incorrect data - are you running a query?

 

[aziz rasul]

It is individual fields.

I am working on VBA code that will transfer data in individual fields that are incorrect and transfer this data into a new table.

The spreadsheet that will be created will hold ALL the data.

I will then, using the forum's help, try to negotiate the table that contains incorrect data with the same incorrect data in the spreadsheet and change the format of the xls cell(s) to highlight the incorrect value.

That's the theory so far.