473,324 Members | 2,511 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,324 software developers and data experts.

How to compare two tables fieldname and then make them to be corresponded

1
I have a question for how tocompare two tables fieldname and then make them to be corresponded. The original file could be CSV or EXCEL, the destination table is ACCESS. How to use VB coding to program two tables fieldname to be corresponded and then using this corresponded reference table to convert CSV and EXCEL file into ACCESS table?

In addition, the history correspondence can be memorized to make this function more clever?

__________________________________________________ ___________
For example:

Original CSV/ EXCEL file:

First_Name,Last_Name,Title,Company,Phone,Fax,Phone _-_Mobile,Email,Web_Page
Jadp,Daas,Sr. Product Manager,Saabase Inc.,(955) 236-5214,(955) 236-6179,,jaadpdas@sabase.com,www.sabase.com
Jbdp,Dbbs,Sr. Product Manager,Sbbbase Inc.,(955) 236-5214,(955) 236-6179,,jbbdp.das@sbbbase.com,www.sbbase.com

Destination ACCESS table structure:
ContactFirst,ContactLast,ContactTitle,ContactCompa ny,ContactPhone,ContactFax,ContactMobile,ContactEm ail,Contactwebpage

------------------------------------------------------------------------------------------------------

Any helps and guidence will be greatly appreciated.

Best Regards,
Anne36
Mar 22 '10 #1
1 1675
vb5prgrmr
305 Expert 100+
ADOX will read the properties of a table (or DAO will) and since it is a CSV file and not an actuall xls file you can use the Open Statement along with the Line Input function to read the first line. Display the field names in one list box and the field name from the CSV after a Split in another. Allow the user to select one from each list box and hit a button "create" to associate CSV with field. Then you will need to save this information into the database or some other file and all of this can be found by using your friends (yahoo, google, ask, answer, bing)...



Good Luck
Mar 23 '10 #2

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

Similar topics

4
by: Maur | last post by:
Hi all, I have 2 tables say t_OLD and t_NEW. The new has corrections for audit purposes. They are identical in all respects (i.e. new is a copy of old and then changes are made to t_new) ...
5
by: Megan | last post by:
Hi everybody- I'm helping a friend with a music database. She has an old one and is creating a new one. She wants to compare records and fields in the old database with records and fields in the...
3
by: PC Datasheet | last post by:
Using code in MyDateBase I create a new database named MyNewDatabase. Now I need to import (or export) using code in MyDatabase tables in another external database named MyData to MyNewDatabase....
2
by: http://www.visual-basic-data-mining.net/forum | last post by:
Hi... Say i have this string call "data" in Form1, this string contains number "5" value.... how do i pass this string to the Form2 and compare with the combo box items... The combo box ...
5
by: Prabu Subroto | last post by:
Dear my friends... I am using SuSE Linux 9.1 and postgres. I am a beginner in postgres, usually I use MySQL. I have 3 tables : appointment, appointment0 and appointment1. the fields of...
4
by: himanshupundir | last post by:
I have two identical tables, now I want to compare them and display the results in a form which looks something like this...CaseID is primary key and it is same for a case in both tables ...
2
by: David++ | last post by:
Dear List, Is it possible to have a schema with tables of the same name? I need to build an XML document based on the following schema - <?xml version="1.0" encoding="utf-8"?> <xs:schema...
22
by: amygdala | last post by:
Hi, I'm trying to grasp OOP to build an interface using class objects that lets me access database tables easily. You have probably seen this before, or maybe even built it yourself at some...
3
by: DeanL | last post by:
Hi guys, Does anyone know of a way to create multiple tables using information stored in one table? I have a table with 4 columns (TableName, ColumnName, DataType, DataSize) and wanted to know...
4
by: psyvanz | last post by:
Im a college student, my program is a computerized enrollment system, Im using MS ACCESS database in connecting my VB6 program form. Inside i'd created two tables, named "tbstudentinfo" and...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.