Search results

Hi I have an import routine that need to detect the type of data being imported based on the model type. The data are on spread sheets that are the same format but depending what the value is in the model field will determine what flags are to be set. my code does not seem to make any...

Works a treat, really appreciated. thank you for all your help, there is so much to learn and so many ways to do it.

Thanks for the reply The product has a max of 69 fields that could be populated. the config data that we get may not contain some of the fields so therefore there may only be 30 fields, this is only for 1 set of records or row at a time. The table i am inserting into already exist and the field...

MajP please accept my apology for the untidy code, i hope that you can read it now. I suppose it is like a an insert query, but when i create a query from the table there are only 2 fields Description and Serial Number. The table they need to go in to has 69 fields and only the serial number...

Hello all really struggling here to get this to work, I need to update a config table, there are 2 arrays array 1 "ImportTableHeaderFields" Single dimension which is basically the field names of the table and Array 2 is "ImportConfig " a 2 Dimensional array of the configuration data Description...

sorry not replied sooner but i have been away. this part now seems to be ok,

Having stepped through slowly and taken your advice Gasman i am now 90% of the way there, i have 2 loops that work correctly. just need to finish off, when the loops match.

Hi Gasman thanks for the reply I will have a look, may be i need to be more specific in that i need to to loop through the rows in the query results and when the description us equal to the input table column name enter the serial number

I have inherited an old database that I am trying to automate, I receive data from a subcontractor to which I have created a temp table. I have written a query to get me the Description and serial numbers of the sub assemblies that are fitted to the product approx 50 in total code below. [SQL]...