Hello all,
I have another question... I would like to remove all rows dependent on the values in two columns.
If column "Header4" includes "X" I would like to remove that row
If column "Header5" includes "Y" I would like to remove that row
The excel sheet contains 100 columns and 300000 rows. What is the fastest way to do this?
The Query for this is: (But I do not have the data in Access, only in one excel sheet)
DELETE *
FROM Table1
WHERE
Table1.Header4<>'XX'
AND Table1.Header5<>'YY'
/P
I have another question... I would like to remove all rows dependent on the values in two columns.
If column "Header4" includes "X" I would like to remove that row
If column "Header5" includes "Y" I would like to remove that row
The excel sheet contains 100 columns and 300000 rows. What is the fastest way to do this?
The Query for this is: (But I do not have the data in Access, only in one excel sheet)
DELETE *
FROM Table1
WHERE
Table1.Header4<>'XX'
AND Table1.Header5<>'YY'
/P