Search results

I have a database that I am working on that I need to move data from the production records that are in excel format (same format everyday, only vary in the number of rows used) to the database. The excel table that is used as the source needs to be wiped clean once it is imported. I know this...

Thanks for the reply. Sorry it took me so long to get back to you to let you know it worked. Next related question, can these be set up to run one after the other? When one is run it overwrites with either the value or blanks it out. Thanks again

I changed all of the field and table names to not have any spaces or "#" in them. Both queries seem to find the correct number of fields to update but I am getting a "type coverstion failure" in both of them I have looked and here is how the fields are set up. line, sample, DateCode are all...

Let me know your thoughts

Thanks for the help. I had to change a few things for spacing and removing the # from line # and such. Having some issue. Going to send you the database so you can see it.

I have a database that I am building to look at the run rates and machine efficiency. I have a table that has the following columns -- "Main" Table -- "Line #"-which production line it was run on "Sample #" -the production order for the day (i.e 1, 2, 3...) "Time in" -time that the product...