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

 

[John Vinson]

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

File... Get External Data... Link
Choose "Excel <your version>" from the Files Of Type option
Link to the spreadsheet
Run an Append query

(how's "free" sound for the cost? Hope I'm not breaking anyone's rice
bowl)

John W. Vinson[MVP]

 

[Dan Artuso]

Hi,
"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."

That sounds like you've designed your table like a spreadsheet.
If there are multiple results for the same lot, you need a seperate table for those results with
a LotId as a foreign key, not six 'results' fields in one table. This will eventually
cause you many problems.

 

[Arvin Meyer]

John Vinson's answer in the newsgroup should be all that you need. If not,
come back and ask a more specific question. We are here to provide high
quality *free* support to Access enthusiasts and users. While it is true
that most of us are professionals that do take on projects that are beyond
the scope of a newsgroup posting, your question is well within the scope of
what we answer.

In the future, I would caution against going with the lowest bidder. That's
great for buying products, but rarely adequate for buying services. A
product is a known commodity with a known value. Services, OTOH, vary in
quality with skills. In general lower skills mean lower quality and lower
price. That's not what most of us are looking for in brain surgeons or in
database developers who are charged with designing our business processes.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access