Selecting Import Criteria In Excel

[Rob]

Hi.

I have a spreadsheet that contains a column called Uploaded. How can I do
an import of this worksheet where Uploaded = "N".

Thanks Rob

 

[John Nurick]

I have a spreadsheet that contains a column called Uploaded. How can I do
an import of this worksheet where Uploaded = "N".

Three ways:

1) Import it all, then delete records where Uploaded="N"

2) Link (or import) to a temporary table and then use an append query
with an appropriate criterion to transfer the data you want to the main
table.

3) Write a query in SQL using syntax like this:
INSERT INTO
MyTable
SELECT
Foo, Bar, Uploaded
FROM
[Excel 8.0;HDR=Yes;database=C:\MyWorkbook.xls;].[Sheet1$]
WHERE Uploaded = "N"
;

 

[Rob]

Thanks John... It worked !!!

I have a spreadsheet that contains a column called Uploaded. How can I do
an import of this worksheet where Uploaded = "N".

Three ways:

1) Import it all, then delete records where Uploaded="N"

2) Link (or import) to a temporary table and then use an append query
with an appropriate criterion to transfer the data you want to the main
table.

3) Write a query in SQL using syntax like this:
INSERT INTO
MyTable
SELECT
Foo, Bar, Uploaded
FROM
[Excel 8.0;HDR=Yes;database=C:\MyWorkbook.xls;].[Sheet1$]
WHERE Uploaded = "N"
;