Erik,  I would suggest setting up a table that contains 4 columns: MaxWidth, MaxHeight, ProductID, Price.  So for your basic price grid you would enter one row for each "maximum height" and...

A few questions that may help:

Is DTS giving any error messages about rows not being transferred? 

Are the table structures exactly the same between the 2 databases? (check unique...

Farrell,  There are no stupid questions, only dumb terminals

But seriously, knowing where to find the answer to a question is half the battle...

Yes, make sure you are using the same user in the ado connection that you are using when testing in Query analyzer.  If they are both using the same userid...

Just to show there are "many ways to skin a cat", you could also create the list in a spreadsheet first and then import it into SQL server with DTS. ...

I installed it one one machine, no problems found so far.

I would agree that would be a good idea.  There should be no issues using dts to transfer from 2000 to 7.0.  There can be issues opening packages in Enterprise...

Books Online is a pretty good source of DTS information.  Search under "DTS, transformation issues" to get some specifics to watch for when setting up your process.

The reason you are getting the error is that you need a related record in the "Parent" table before creating the "child" record.  I would recommend doing some reading on...

The other main difference between dates in Access and SQL Server is that you have to specifically consider the time part in SQL Server.  For example checking where Datefield='1/1/05' it won't match...

No, as far as I know there isn't a setting.  I think you'll have to do it "the hard way"

You could also just run a delete query on the table in Access and then import your file.  You could roll it all up in a macro or code to...

Setting nocount on means the results of your SELECT statement won't be returned as results of the procedure, they will just be used inside it.

I read it each week and am getting a lot out of it.  Keep up the good work!

Andrew

4 total... 

- 1 "desktop" in the living room running Win2000 and hooked into the tv for music control and slideshow viewing

- 1 desktop running XP home for my wife's office (she runs...