importing from excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I developed a form that runs a few queries, that ultimately calculates
percentage. all the queries run off of my one table called technicians. I
have a horde of excel files that need to have their info listed on this
table. All the fields are exactly the same on the technicians table and the
excel table. How can I import them so they all show on the one technicians
table? If impossible how might I transfer this data moore easily??? Thank
you all.
Nick
 
Use File | Get External Data ... | Import menu to import each file into a
new table, then use an append query to copy the data from that table into
your Technicians table.
 
Back
Top