importing data from excel

[nerd19]

im try to create a automated batch update feature to one of my tables. What i have is a table, Tools, that consists of: serial, size, date_serviced, status, employee. The excel file i need to import can be called xlTable, but it contains too many fields; tool serial, serviceID, size (inches), size (metric), operator. What i need to be able to do is import only the tool serial and size (inches) from xlTable to my Tools table and have the date_serviced and status be a default value i have and the employee a value taken from a form or input pop-up box.

So what i am hoping to do is create a form, have the user input an ID and location of the file then click an 'update' command button and the batch update would update the table.

Is this possible to do in MS Access 2000? or is there a better way to go about doing something similar to this?

Thanks for the help.

 

[maxhugen]

Check out the TransferSpreadsheet method in Help. You can specify a Range of cells to import.

Another method is to import it 'as is' to a temporary table, and then create an Append query using this temp table - this will let you select only the fields you want, and also specify the default values you need.

Max Hugen
Australia

 

[nerd19]

how would i make the table temporary? also if i wanted to iterate through the records would i use the bookmark feature?

thanks