Imported Dataset manipulation

[InDistress]

Howdy all,

I need alittle help here. What I'm trying to do is import an excel worksheet as a dataset then I want to query my database dataset to fill in details in my imported dataset. That sounds alittle confusing I know, but effectively, I have a dataset that my application utilises for it's own functions, and what I'm ultimately trying to achieve is to allow the user to import an excel file and have 4 seperate columns of data added to it (obviously once the data has been filled in on my imported dataset I'm exporting it as an excel file).

The problem is how to ammend my imported dataset with data from my applications dataset, oh and I should mention that the data I need filled in is based on values in 2 columns of my imported dataset.

So to help clarify it more, my applications dataset has the following tables:
ASGC_2006_Structures_local
LOCS_ASGC2006_JUL06_local
pcimport_local

Now, when I import my excel file as a dataset, I want to use the values in the 'Postcode' column and 'Suburb' columns in my imported dataset to query my ASGC_2006_Structures_local table and LOCS_ASGC2006_JUL06_local table then if a value is returned, return it back to the appropriate row in a new column in my imported dataset.

I know it all sounds alittle dodgy, but I was advised that this way would be quicker than using a COM object to connect to Excel and append the Excel file that way.

If you need anymore help trying to understand what it is I want to do then please don't hesitate to respond.


Thanks in advance.

InDistress

 

[cjard]

I'd actually do:

Import Excel data into dataset
Send excel dataset data to the database
Perform a JOIN query from the database, into my database dataset

 

[InDistress]

I'd actually do:

Import Excel data into dataset
Send excel dataset data to the database
Perform a JOIN query from the database, into my database dataset

Cheers for that cjard.

One small question, Do I import the excel file as a new datatable into my existing dataset or just keep the import into a new dataset?

 

[cjard]

Cheers for that cjard.

One small question, Do I import the excel file as a new datatable into my existing dataset or just keep the import into a new dataset?

Wouldnt really matter, youre going to have to move the data from exceldataset(table) into the databasedataset(table) anyway. It matters not whether these two datatables are part of the same set or not