What is the most efficient way to do a vlookup from excel to an access
database? I can't lookup to the excel file because the data is 96,000
lines long.

Thanks-


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

most worksheet functions will not work with an external source, unless you
first bring the data into Excel.

You would need to write code that does the query.

Is that what you are asking for?

http://www.erlandsendata.no/english/...odao/index.php

------------------
Andy Wiggins also recommends the worksheet function sql.Request for this
situation:

----extract from Excel help for SQL.Request----
Connects with an external data source, and runs a query from a worksheet.
SQL.REQUEST then returns the result as an array without the need for macro
programming. If this function is not available, you must install the
Microsoft Excel ODBC add-in (XLODBC.XLA).
-------------------------------------------------



Andy Wiggins:
This might be a help for getting data to and from Excel and Access: It
includes examples of using variables in SQL queries.
http://www.bygsoftware.com/examples/sql.html

Or you can get there from the "Excel with Access Databases" section on page:
http://www.bygsoftware.com/examples/examples.htm

It demonstrates how to use SQL in Excel's VBA to:

* create a database,
* create a table and add data to it,
* select data from a table,
* delete a table,
* delete a database.

DAO and ADO files available.

You can also download the demonstration file called "excelsql.zip".

The code is open and commented.


--

Regards
Andy Wiggins
www.BygSoftware.com


--
Regards,
Tom Ogilvy

chris huber wrote in message
...

What is the most efficient way to do a vlookup from excel to an access
database? I can't lookup to the excel file because the data is 96,000
lines long.

Thanks-


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

This file might be a help:
http://www.bygsoftware.com/examples/...SqlRequest.zip
It's in the "Excel with Access Databases" section on page:
http://www.bygsoftware.com/examples/examples.htm

This workbook demonstrates how to get data direct from an MS Access table,
or from an open or closed MS Excel workbook using the workbook function
SQL.REQUEST.

Recently updated to show the use of SQL.REQUEST in the same workbook.

The code is open and commented.


--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"


"chris huber" wrote in message
...

What is the most efficient way to do a vlookup from excel to an access
database? I can't lookup to the excel file because the data is 96,000
lines long.

Thanks-


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!