I need a little help, and have a couple of questions, and I was wondering if you guys could help me.
This is the start of it, which works fine, it basically imports data from data source supplied by a third party, unfortunatleythe only issue I have with the data is no identifying data to say which site it has come from, in this example the site is (11771), so what in need to do is this, after the data has been imported, I need to update the SiteID Column within the table with the site id, what is the code that I require to carry out the update ???, i cant find it
Second question: in the path of where the data is located, can the 20090228 be driven from a form e.g. "D:\sites\S11771\[Form1].[Date].vpn\cbrp.csv",