I need an Access programmer

[analyst]

I need a macro, or query, or whatever will work, to move data from an Excel
file into an Access database.

I move info via a query from Access to Excel all day long. I've programmed
VBA code in Excel for years. But I don't know what I'm doing in Access, so
putting it back into the Access database where it belongs is new for me.

An Intel Database Management Pro suggested I ask a local College Prof if any
of their students would like to make some Christmas cash, but the schools
are out for vacation.


IS THIS the place to post for finding an Access educated programmer? If not
then where do you suggest?


We test material for strength and chemistry, and our equipment saves the
data in an Excel file. I need the macro to read the Excel file, and insert
the results into the Access database in the right spot, i.e. the correct
Lot# and Part#. That Lot may already have results, so it may need to go in
the second results field, or third, or fourth... or notify the user there
are already 6 results and it's full.

This has GOT to be too easy to do, but I haven't had time to sort it out.

There's cash on the table for the lowest bidder who can get it done.
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

contact me at: (analyst AT khametal DOT com) -THANKS

 

[Sylvain Lafontaine]

Create a linked table to your Excell file and you will be able to read from
it like any other Access table.

S. L.