I would take the route that ipTomN stated

However, the question you need to ask before starting work on this is: How do you establish the entity relationships for the data...

Hehe... I have had my bad days with inexperienced programmers as well.

I am in a career position where I am both DBA and programmer for my organization. Most...

I also have to concur that the programmers should address this issue, not the DBA.

As a programmer, I know that it is important to create applications that manage resources efficiently....

I had a similar situation when I worked for a previous employer, but I approached the problem in a different manner.

We had about 60 different customers that provided us data...

I have two SQL Server books.

One is for all of the basics involving SQL Server 2000.

It is one of those SAMS Teach Yourself SQL Server 2000 in 21 Days books....

In all the applications I design, I plan to always use OLE-DB. In applications that may be implemented in other network environments, I have to design the application to...

I hope this will be a simpler explaination...

OLE-DB connection libraries are the compiled "native" dlls that allow any application to connect to the database they are desiged to communicate with....

LOL... been there and done that!

Sometimes it takes just examining the data file in fine detail to identify potential gotchas. A good text editor always seems to be...

You also may want to check out some of the tools here: http://www.apexsql.com/

I have a feeling that your not going to get any close numbers. The best you may find, if anything, is an educated guess.

Case 1) Many small...

Pardon the blandness of the code, but I can only guess at the table design you are working with.

Assuming the following:

-ForumUsers table has all forum user data and has a...

Oops... found an error in my code above...

This is more correct

sql="Update Student "

sql=sql & "Set stud_fname = '" & fullname & "', "

sql=sql & "stud_id = '" & stud_id...

First

Make sure you can open and close the connection object without errors.

If that works clean, then try the following approach:

set conn=Server.CreateObject("ADODB.Connection")

conn.open="dsn=FLAMINBUTT; db=cybercounsel; UID=cyber; PWD= counsel"

sql="Update Student "

sql=sql &...

I would approach this problem in different manner.

Using the method of your choice (batch file, VBS script, compiled program, manual labor, whatever it takes) make a copy of the latest...

I have been dealing with this common EDI issue for many years now.

Although there are many different formats that the name can be formatted in, there are also many unique...