Importing data from access.

Originally Posted by mattyj198

I am just starting to work for a new company, we have data sheets that we fill information into on excel. I know the company has a database of all the data that needs to be imported into the excel sheet. Basically right now we print the database off and copy the information into the excel sheet. It’s all basic information about batteries.

Serial Number
Battery Number
Site location
Amp hours
Volts
Stuff like that, and below we enter monthly readings of voltages and gravities. That part I know has to be entered manually. But the stuff shown above is very time consuming to enter. I know there is a way you can just type in the battery number and the rest of the fields should fill in with the corresponding information. If someone could help me out with this... It would save me HOURS each day.

My goal is to be able to take a laptop to the battery and place the cursor on the battery number cell in excel and use a barcode scanner to scan the battery and have all the batteries information to fill in the rest of the cells.

Eg, Serial Number
Battery Number
Site location
Amp hours
Volts

Then we can just fill in the rest manually.

Thanks a bunch

Mattyj

HI,

If you export the Access file as a .csv you can input that to Excel to use as a table. You can then use the table via a lookup, asin

=VLookup(A1,Table!A:E,2,False)

where A1 represents the scanned number. Table! represents the sheetname of the table, and A:E is columns Serial to Volts

=VLookup(A1,Table!A:E,5,False)

to see the volts.

Does this help?
---