This is driving me nuts!:banghead:
Records are exported from Excel to Access. Excel contains formulas for up to 200 records. (This is updated daily with data so no way of knowing each day how many rows with formulas are needed). I have two worksheets - GAMLS, where the original data resides, and Converted, where I have to do some clean up work on the original data. So all the records in the Converted worksheet are linked to the original data on the GAMLS worksheet. Formulas have been written with sort of a prelude that basically says that is the row is blank on the GMLS sheet, then show them as blank on the Converted sheet. Now, the rows on the Converted sheet are not really blank -- they contain formulas, but show blanks where there are no matching records. No problems with all this.
However, when I import the worksheet range into Access, it, of course, imports all 200 records, when, for example, today there are only 46 actual records, and the rest is just formulas.
So, I am trying to get a Delete Query to delete the records from within the Access table (TBL-GAMLS) that have blank rows. (In this case, there are 46 actual records and 154 "null" records.
I did this exact same thing with a separate spreadsheet and have no problems with it importing and doing the delete query.
I need to base this on the address field, so I'm saying that if the record doesn't show any address, delete it. But, if I use Is Null for the criteria for the Address field, (even if I change it to a Select query just to see), it basically does not find any null records.
Although I did this before using a separate spreadsheet (all this is in one database), the other one works, this one doesn't and I'm pulling my hair out.
If it would be easier to solve by actually seeing the spreadsheet and the database, I would be happy to share through DropBox with anyone who may be able to help me. This is crucial to the database.
Thanks to anyone who can help!!!
Records are exported from Excel to Access. Excel contains formulas for up to 200 records. (This is updated daily with data so no way of knowing each day how many rows with formulas are needed). I have two worksheets - GAMLS, where the original data resides, and Converted, where I have to do some clean up work on the original data. So all the records in the Converted worksheet are linked to the original data on the GAMLS worksheet. Formulas have been written with sort of a prelude that basically says that is the row is blank on the GMLS sheet, then show them as blank on the Converted sheet. Now, the rows on the Converted sheet are not really blank -- they contain formulas, but show blanks where there are no matching records. No problems with all this.
However, when I import the worksheet range into Access, it, of course, imports all 200 records, when, for example, today there are only 46 actual records, and the rest is just formulas.
So, I am trying to get a Delete Query to delete the records from within the Access table (TBL-GAMLS) that have blank rows. (In this case, there are 46 actual records and 154 "null" records.
I did this exact same thing with a separate spreadsheet and have no problems with it importing and doing the delete query.
I need to base this on the address field, so I'm saying that if the record doesn't show any address, delete it. But, if I use Is Null for the criteria for the Address field, (even if I change it to a Select query just to see), it basically does not find any null records.
Although I did this before using a separate spreadsheet (all this is in one database), the other one works, this one doesn't and I'm pulling my hair out.
If it would be easier to solve by actually seeing the spreadsheet and the database, I would be happy to share through DropBox with anyone who may be able to help me. This is crucial to the database.
Thanks to anyone who can help!!!
