how can i import data from 1 access table to 2 joined ms sql tables? 2

[aldi]

Hello all,

I have a task to import data from one access (2000) table to two ms sql (2005) tables.

The ID of TableA has to be inserted in a field of TableB so that the tables can be linked on those fields.

How can i do it using SQL Server Import and Export Wizard?

I know how to use the wizard, but have no idea on how to insert the data on two tables at same time, so that the id of tableA gets into a field of tableB

I've been searching for answers but only find how to import from one table to another.

Please help!!!!!!!!!!!

I'll appreciate any kind of help, hint or link to read.

Thanks in advance!!!

 

[markros]

BTW, I think the user can only give star once to the same person in one thread. But don't worry, I read your request.