Data transfer from AS400 to SQL-7.0??

[Guest.Visitor]

I am using DTS to transfer tables from AS400 to SQL using a Client Access Express connection. When I get a list of the source tables within the DTS wizard they all begin with "*N" which SQl doesent like. If anybody knows why this is hapenning or a way to get around this I would appreciate the help.

[Guest.Visitor]

Jeff, This could be a twist on what usually bites people transferring into Excel. See if you are missing a Relational Database Entry for your machine.

AddRDBDirE RDB(your AS/400's network name) RmtLocName(*Local)

Bill

[sundersham@hotmail.com]

Hi, Has any one tried to copy a table from SQL6.5 to AS/400 directly? Thanks Shams