Importing And Comparing A Table From Excel

[David92595]

Hello,

Basics: I'm running a SQL server 2008 R2 back end with an Access 2007 Front end.

I need to find a way to run a SQL report based off Primary Key (numbers) from an excel spread sheet. There are a few hundred so I need to find a way of Importing the spread sheet and comparing it against an existing table or query.

As always, any help is greatly appreciated,



David92595

[June7]

Is the Excel sheet data structure simple enough that Access could just link to it? Linked sheets can be used much like an Access table, except maybe for editing the sheet data.

[David92595]

I think so I have no experence linking sheets, but the excel spread sheet is simple in form, and all I really need is the first column...
So I think it's a yes, what else can you tell me about linking to the excel file and how would I compare that against a table or query?

David92595

[June7]

What do you want to compare? Do you want to know if the data in the sheet exists in the SQL table? Build queries that join the tables. Try the Find Unmatched query wizard.

[David92595]

I want to pull in the first column of the excel document and run a report using the numbers in that first colum (they are the PK numbers in our database). so I need to compare it against our database and return a query to pull the other needed information.

[June7]

Still don't know what you mean by 'compare'. Link the sheet and build queries. When you encounter specific issue with that effort, post question.