473,394 Members | 1,749 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Compare Access With Excel Vba Help Please!!!

Hi everyone, i`m trying to make access interact with excel in vba

I have an excel sheet with 3 columns and 30 rows, and an access table of 4000 rows.

The idea is to compare every row of the excel from only one column with every row of my access table from only one column of the same type.

For examle:
My excel has 3 columns: Code, Name, City.
My access table has 4 columns: Code, Name, City, Country.

I want to compare every "Code" of my excel, with every "Code" of my access to find the matches IN ACCESS.

If any could help me with this I would be very very pleased!!
Aug 10 '07 #1
0 928

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Neil | last post by:
I have writen a basic database to keep a register of autocad drawings but now i need to do something clever and i have no idea what to do! i need to find a way to send a email to people with the...
1
by: tkaleb | last post by:
I have to create output file in a text, MS Access, MS Excel and .dbf format from C# Win/ADO.NET application. Data are collected in DataSet and there is no problem to make text file. However, I have...
3
by: Omar | last post by:
Hi Developers, I am trying to access an Excel data file through a VB.Net application. I have the following code: =================================== VB.Net Code =================== Dim...
3
by: James Wong | last post by:
Dear all, I have an old VB6 application which can create and access Excel object. The basic definition statements are as follows: Dim appExcel As Object Dim wkb1 As Excel.Workbook Dim wks1...
1
by: Sean Howard | last post by:
I have an Access database/procedure that exports data to an Excel spreadsheet and opens that spreadsheet using automation I need to change the current directory/drive in Excel to be the same as...
4
by: Keith Wilby | last post by:
How controllable from Access VBA is Excel? I'm currently using automation to dump 2 columns of data into an Excel spreadsheet so that the end user can create a line graph based on it. Could the...
3
by: pochimen | last post by:
Hi everyone, i`m trying to make access interact with excel in vba I have an excel sheet with 3 columns and 30 rows, and an access table of 4000 rows. The idea is to compare every row of the...
4
by: Nisio | last post by:
Guys Here's my prob. I work with a group og non-techie guys who are non-PC literate but need to produce exacting detailed reports on a regular basis. They are living proof of a little knowledge...
0
by: Nadirsha Muhammed | last post by:
How to access excel function wizard through C#
2
by: naaniibabu | last post by:
How to upload a values from notepad or (Mainframe fields ) into Excel Sheet ? How to save it ? After getting the values i want to compare 2 excel sheets ? Pls help me anyone for the above...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.