Access DB and Form Fill using CSV?

%3CLINGO-SUB%20id%3D%22lingo-sub-1882835%22%20slang%3D%22en-US%22%3EAccess%20DB%20and%20Form%20Fill%20using%20CSV%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1882835%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20team%20works%20off%20of%20lists%20that%20are%20printed%20out%20weekly%20and%20give%20the%20same%20pieces%20of%20information%20(ie.%20Building%20%2F%20Room%20%2F%20Rack%23%20%2F%20Blade%20(if%20applicable)%20%2F%20Fuel%20Type%20%2F%20Serial%20Number)%20for%20different%20pieces%20of%20equipment%20each%20time.%26nbsp%3B%20They%20generated%20from%20a%20DB%20kept%20in%20MS%20Access.%26nbsp%3B%20These%20lists%20are%20then%20used%20to%20address%20preventative%20maintenance%20of%20equipment.%26nbsp%3B%20We%20fill%20out%20a%20new%20form%20for%20each%20piece%20of%20equipment%20when%20we%20get%20on%20site%20and%20begin%20the%20work.%26nbsp%3B%20It%20is%20possible%20to%20export%20this%20list%20as%20a%20CSV.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20wondering%20if%20it%20would%20be%20possible%20to%20use%20this%20information%20to%20generate%20the%20forms%20with%20the%20header%20information%20filled%20out%20ahead%20of%20time.%26nbsp%3B%20There%20are%20two%20forms%20one%20for%20the%20rack%20then%20another%20for%20each%20individual%20blade%20within%20the%20rack.%26nbsp%3B%20The%20rack%20header%20asks%20for%20Building%2C%20Rack%20%23%2C%20and%20Rack%20SN.%26nbsp%3B%20The%20blade%20asks%20for%20Building%2C%20Rack%23%2C%20Blade%20ID%2C%20Fuel%20Type%2C%20Blade%20SN%2C%20Blade%20control%20SW%20version.%26nbsp%3B%20In%20the%20end%20I'd%20like%20to%20leave%20the%20SN%20and%20SW%20information%20blank%20to%20ensure%20they%20are%20updated%20manually%20on%20site.%26nbsp%3B%20The%20other%20information%20I'm%20hoping%20to%20pull%20in%20and%20populate%20the%20header%20of%20however%20many%20sheets%20there%20are%20lines%20on%20the%20master%20list.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1882835%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

My team works off of lists that are printed out weekly and give the same pieces of information (ie. Building / Room / Rack# / Blade (if applicable) / Fuel Type / Serial Number) for different pieces of equipment each time.  They generated from a DB kept in MS Access.  These lists are then used to address preventative maintenance of equipment.  We fill out a new form for each piece of equipment when we get on site and begin the work.  It is possible to export this list as a CSV.

 

I'm wondering if it would be possible to use this information to generate the forms with the header information filled out ahead of time.  There are two forms one for the rack then another for each individual blade within the rack.  The rack header asks for Building, Rack #, and Rack SN.  The blade asks for Building, Rack#, Blade ID, Fuel Type, Blade SN, Blade control SW version.  In the end I'd like to leave the SN and SW information blank to ensure they are updated manually on site.  The other information I'm hoping to pull in and populate the header of however many sheets there are lines on the master list.

2 Replies

@John_Hawkins_SPS This sounds like a development question, want me to have a look at it?

@BellsITMelb57 thanks for the reply!  My concern with having someone outside the company work on this is whether or not there would be a charge that would be incurred and I'm not sure I can give out the database and its information.  Is this something that training could be provided for?