One last thing I'm wondering is why is there a refference from Persons to party like that?

It's my understanding that normally a person will attend more than one party in...

I think you're going backwards on this.  You normally insert the data in the parent table, fetch the new identity value.  Then use that to insert in the child table...

You have to put all the code from the cursor declaration all the way to its deallocation in the dynamic sql, then run that in a single run.  That's because...

I never had any experience on that matter.. the only time I used a remote data source was when I had to work with a 3rd party budgeting software.  I...

Well comparing Access and Sql server is like comparing a Lada to a Ferrari. It always depends of what they are doing but I would much preffer transfering everything...

I'm not the expert in mass data importation but I really don't think it's that slow either (remember importing 300K large rows of data in just a few seconds).

However I'm...

I think that the safest way to find out is to ask around in the company... maybe the secretary or even programmers. If you have the nerve you can...

Same thing... However you must use the right pane to use the multi-select feature. I forget the name of the tab but there's one that list all the objects...

Now that I think of it, no. But any way you ask it there's always a way to run to QA and test so I would not even...

Thanx for the links. I had already met part of the problem with strings like ',' or ',' but that's about it. That would be a nice gotcha...

Ya this seems like the safest solution... I don't think you can assume anything here and "hope" that an update statement will fix all 100% of the data without any...

Well I don't really know what you need to keep so I'll refrain to only the software problem.

You could always have a Softwares table (SoftwareID identity(1,1) PK Clustered, SoftwareName (Unique)).

Then...

What is blocking you from automating this process and not having to intervene at all?

I had thaught about this... but isn't it possible that someone included a comma in their adress manually?

Thanx for the info... I didn't know that about the IsNumeric Function .