MS Access to DB2

[krotha]

I have about 100 MSAccess tables which needs to migrate to DB2. What is the best way to do it. I migrate to SQLServer 2000 sucessfully, but my goal is DB2.

Any help is appreciated.

 

[elsenorjose]

Maybe best posted in the Access forum?

http://tek-tips.com/threadminder.cfm?pid=181

You tend to get much better responses when you post in the appropriate forums.

Best of luck!

 

[onpnt]

The access forum may be better but sense you are in sql server I would leave it there and transfer to db2 from that engine.

sql servers transform services are going to be far better than, well none in access ;-)

If you have the DB2 provider on your machine (or server) just use DTS to transfer the data. Just make sure it is located in the correct table space and such on DB2. You'll have to edit the data types in the transform of course.


[sub]____________ signature below ______________
I am Tedward Keyboardhands!!!
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]

 

[onpnt]

oh and I would post any and all questions to --> forum961


[sub]____________ signature below ______________
I am Tedward Keyboardhands!!!
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]

 

[krotha]

Thaks guys. DTS worked ok. Next time I will post in appropriate forum.