manipulate excel data from within Access

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

Guest

Hi all

I am stuck -

From within Access, I need to be able to open up an excel workbook
(preferentially with a prompt for the user to select the workbook), then copy
and paste special (on values), the data into a new file and save the new file
in a specific location (say C:\Access)

I then need to import the new workbook into a temporary access table so I
can then append the data and manipulate it.

Can anyone help me out with the code I need????
 
How sophisticated are you trying to get? If this is supposed to be a
multi-user, user-friendly system, then you'll have to devise VBA code for MS
integration (using Excel commands from within Access). This will involve
some programming skulduggery but it isn't really hard, just difficult to get
used to. If you are using your tool by yourself, why not make this a
two-part operation. Go into Excel for your cutting and pasting and saving,
then into Access for the append or update query to move the data into that
environment? Not as fancy but it'll get the job done.

Steve in Ohio
 
Back
Top