imported selected fields to table from xls file

[dileshw]

Hey guys,
I have a .xls file. Lets call it "MyExcel.xls". And I have a .mdb called "MyDB.mdb" and there's tw tables 't1' and 't2'.
I want to import some selected fields of Myexcel.xls into 't1' and 't2'. t1!=t2.
and t1 and t2 have a particular coloumn order that i need to follow and myxls is also of a fixed unchangable column order.
All tips appriciated!

[jimatqsi]

Try linking to the Excel sheet. Then you can treat the Excel sheet as an input table and create a query to pull data from it. You can find the link tool under File / Get External Data / Link.

Jim

[dileshw]

Thanks!
IU am trying that, and it seems promising, but i have another issue now:

My DB has 3 tables T1, T2 and T3. and the relationships are as follows:
T1.primaryKey = T2. forignKey
T2.primaryKey = T3. forignKey
But T2's PK is an autonumber that MS access generates, and this automumber is generated only when a record is created in the DB. So if i were to append the records that i extracted from the xls file, there wont be a PK. Ehnce, there wont be a auto number in T2 for T3 to be linked to.
Anyone got any idea?

[jimatqsi]

You didn't mention T3 in the original post, so I am assuming you are not yet building that in this xls import operation. That being the case, there is no problem. When you are creating T2 you supply the foreign key to T1 and they system will supply the primary key to T2.

Also, please note that you should not append a new question on an existing thread. A new thread should be started for the new problem/question.

Jim

[dileshw]

Thanks Jim. Sorry, I thought it might be easier for someone to understand the problem if they knew the background to it. Lesson learnt for next time :)

thanks again!