trying to automate excel import

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

Guest

I am trying to automate the import process of data received on a weekly
basis. As it stands now, I am having to manually go into Excel and re-save
to the current format before importing. otherwise, Access says that there is
no data on the .xls. After that I am manually going thru the mothions to
imprt into an existing table.

Is their an automated procedure that I can do to get this done?
 
1) You can use from the file menu - "Get external data" - Linked tables.
A wizard is offered to import your excel data (choose .xls from the file
type menu)
every time you open access the newest data from the excel will be available
thru a access table.
Pay attention for open files.
2) Do it completely manually by code
set a reference in your vba editor to the microsoft excel object and the use
the code (check also the microsoft.public.access.modulesdaovba newsgroup for
this issue)

dim oXl as excel
dim oxB as excel.workbook
dim oxS as excel.worksheet
[]

And so on...
It seems complicated at start, but the possibilities are endless! :-)

Kind regards
Damiaan
 
Back
Top