A
Arvi Laanemets
Hi
The situation:
From a 3rd-party program, monthly some reports are saved as Excel files.
They don't have proper table structure, p.e. there is some additional info
in cell A1 (report header), and in I1 too (report date), the header row is
3rd one, actual data start from row 5, and the last row contains some
summary values. And there are some abundant columns too. I need to import
those reports into acess.
So long I have used a special Excel file as intermediate agent. When import
routine is started, the old table is cleared, user is asked for source file,
the source file is opened and checked for being the right one (p.e. the
report header is checked), and then the table is filled (Do While cell in
column A doesn't contain "Summary"). After that the Excel is closed. Now the
user starts Access project, and imports new data from intermediate Excel
file (add table query).
It works, but there are too much steps. What will be a best course to do all
importing directly from Access?
Thanks in advance for your help!
The situation:
From a 3rd-party program, monthly some reports are saved as Excel files.
They don't have proper table structure, p.e. there is some additional info
in cell A1 (report header), and in I1 too (report date), the header row is
3rd one, actual data start from row 5, and the last row contains some
summary values. And there are some abundant columns too. I need to import
those reports into acess.
So long I have used a special Excel file as intermediate agent. When import
routine is started, the old table is cleared, user is asked for source file,
the source file is opened and checked for being the right one (p.e. the
report header is checked), and then the table is filled (Do While cell in
column A doesn't contain "Summary"). After that the Excel is closed. Now the
user starts Access project, and imports new data from intermediate Excel
file (add table query).
It works, but there are too much steps. What will be a best course to do all
importing directly from Access?
Thanks in advance for your help!