Importing Excel Files to Multiple Tables

[Aviosity]

Hey all,

For now, I've decided on changing the schema so that I won't have to buy any third-party products. One problem I'm consistently running into is the import feature; how do I import Excel spreadsheets to multiple tables? I can import into one table, but not the other; I need to be able to place three columns of the Excel spreadsheet into one table, and the rest (10) of the columns into another.

Sorry if this is in the wrong forum; I considered this to be a scripting error, although I may be wrong. I appreciate any help anyone can give me.

Thanks,

Aviosity

[-Queue-]

Use two import scripts, one that goes to a layout associated with TableA and imports and one that goes to a layout associated with TableB and imports.