Selecting Import Criteria In Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I have a spreadsheet that contains a column called Uploaded. How can I do
an import of this worksheet where Uploaded = "N".
Click to expand...

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"
;
 
Thanks John... It worked !!!

John Nurick said:
I have a spreadsheet that contains a column called Uploaded. How can I do
an import of this worksheet where Uploaded = "N".
Click to expand...

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"
;
Click to expand...
 
Back
Top