Imported queried and then Exported Report

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

Hi
I am not sure even where to being doing this
I have a qry and I have an external table (exl) that
needs to be monthly "dumped" or "linked" or matched to
existing fields in a qry
and this data combined would need to be exported into a
report (monthly) and the old data can not be lost.
It is a large phone db and bills come in monthly which
need to be matched to phone qry in the db.
I am not sure how I manually or programmically import
that file (limited fields inputted)
and then, run the qry and then produce a report that
needs to be transferred back to an exl or rtf file.
Please if anyone could advise.
Mary
 
You could just link to your Excel spreadsheet.
And as long as your Excel file has the same name and layout
you just save every month's excel file as the name of the file used in
access
and access wont know the difference.

You can run your cqueries with excel as the linked table and export the data
back to a different Excel file
or to a CSV file. I 'm not certain about rtf - but perhaps you can export a
report as an rtf

HS
 
Back
Top