Append a Record into 2 tables

[litsz02]

Maybe I'm having a brain disfunction, but I'm just trying to map this out in my mind...Seems simple enough tho...

I have some records in Excel that have certain columns belonging to two different tables that I need to import into a SQL server database. For example Col1, Col2 go in Table1, and Col3 and Col4 go in table 2.

Table1 is a Order table, while Table2 is Order Line Items.

Table1 has an autonumber field for the key. They are linked by this number.

In my Excel record I have some columns that need to go in that first Order table, while some in the same record need to go in that Line item table.

Can someone show me what is the best way to append these records into these 2 tables???

 

[philhege]

What's your connection scheme to the Excel data? Are you uploading or querying through a link server?

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Eschewing obfuscation diurnally.

 

[litsz02]

Oh I just have some data with a couple hundred records I need to import into Excel.

 

[litsz02]

import FROM excel into Access, excuse the above post.

 

[gmmastros]

This forum is for Micrsoft SQL Server. In many cases, the SQL Syntax is the same, but not all. The syntax is VERY different for importing data.

I suggest you post your question in one of the Access forums.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[philhege]

Tks, George; beat me to it.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Eschewing obfuscation diurnally.

 

[litsz02]

Ah ok will do...I guess I was just in this mind set because I have a SQL server back end with an access front end...

I'll repost over there...Thanks!!!