hi! I need a program in vb that does this as soon as possible, I'd be very grateful if anyone could tell me how to do it:

the customer gives a table containing the old values and new values in an excel sheet which will be connected to an access table.
then the program checks for multiple new values for the same old value and after the user has corrected the values,
shows a form that takes a server and MSSQL database name and after connecting to and opening it, if a value in
it's table(like vouchers_no) is equal with a value from the access table in the oldvalue field, it replaces it's
value with the value of the newfield value of the same record.

1) Commas aren’t periods.
2) Capitalizing the first letter of each sentence makes it so that others don’t need to decrypt your post.
3) The fact that you are posting here is sufficient notification that you need help—no need to use that as a subject line. A good subject for this would have been maybe, "Processing Excel Data." Or maybe, "Hard Homework Problem." Which brings us to
4) Very few people here will do your homework for you. We will be happy to help with technology issues, like "How do I read the values in Excell cells?" or "How can I take user input form a form, and use it to open a connection to a server?" (Or "to MS SQL?")


Liberty’s good though (from your username)—I’m all for it!

I'm really sorry! My English is not very good and I was in a real hurry when I wrote that post. Plus this is my first posting on a board like this so I really didn't know what and how to post it.
And just FYI it's not my homework.

Thank for answering and pointing these out to me. I'll pay more attention next time.

Well than, how is it that you come to this problem, if it is not homework? (You must admit that it looks a lot like a homework problem...)

Can you give a step-by-step to clarify what you need to do?

Recieve a table from the customer. (This table's information represents ? ? ?)
The table is contained in an Excel spreadsheet.
Access will be linked to this file's data.
(etc.etc.)

BTW: your second post is much better; thanks.

I agree with Brian. I have no idea what it is that you are asking for. It seems that you will have a CSV file that needs to connect to a SQL Sever that connects to an access database??

I should also point out, noone here is going to write this program for you; give you advice on how you *could* create sure, there are plenty of people that can give you advice on that.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

someone asked me to write it because he needed something like that and didn't have time to do it himself.

The customers have a table 'vouchers' in their accounting database. They want to to replace the current values of the fields 'voucher_no' with a set of new values. they have the old values and the new values to be assigned in an excel sheet. now I'm supposed to write something that will replace the current values in the 'vouchers' table with the new values from the said excel sheet where the old values match.


I don't want someone to write it for me. I've got it almost done, I just have a few problems such as these :
The program takes the server and database name to open. I don't know exactly how to open the database with them correctly.

Or does 'movenext' work on MSSql tables? I get an error when I use it on mssql but the same statement works fine when I use it on access.

Plus I just wanted to know if someone had a better idea. I was hoping someone could tell me something like "go this way or use this feature ..." I wasn't asking anyone to do it for me.

hi there.. is this one time only operation??

b/c this will be better to do by hand...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========