Excel to Access...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mseifert_99 - 17 Jan 2006 20:30 GMT

First off let me say that I know that this is not a Access Forum .. but
I have tried repeated to get my data into a Access table and it is not
working.. So this is what I am hoping to accomplish in Excel... Since
my knowledge of Excel far exceeds my knowledge of Access...

What I want to do is put a command button in Access that opens an Excel
add-in spreadsheet. then it will at first prompt you to select a file to
manipulate and then when the file is opened manipulate the spreadsheet
the way that I want it to. So that I can import it into Access...
Without having to do all the crazy calculations in an Access Query ...

Hopefully someone can help ....

Signature

mseifert_99

Reply to this Message

LeAnne - 17 Jan 2006 21:42 GMT

Hi,

I think you're going to have to provide additional details. Are you
using a command button on an Access Form? Does the button run a macro or
a procedure? Are you trying to open Excel from Access (macro=RunApp
action, Shell() in VBA)? Are you trying to import data from a single
linked spreadsheet into your db? Or choose from several spreadsheet
files? What kind of file are you trying to open after you fetch the
Excel data? What kind of "manipulations" and "calculations" are we
talking about?

LeAnne

> First off let me say that I know that this is not a Access Forum .. but
> I have tried repeated to get my data into a Access table and it is not
[quoted text clipped - 8 lines]
>
> Hopefully someone can help ....

Reply to this Message

mseifert_99 - 18 Jan 2006 16:32 GMT

Ok let see if I can answer some of this...

The command button... The command button would be in Access to open the
Excel spreadsheet that has the marco/procedure to manipulate the
data...

The file to be manipulated would be a Different Excel Spreadsheet each
time.. The spreadsheet would be coming from a piece of test equipment
that outputs the results data in spreadsheet format.... So I would need
soemthing like a Excel add-in file....

The calculation/and manipulation would not be anything complicated...
An example of the calculation would be something
=max(abs(CELL"X":CELL"Y") or maybe a
IF(CELL"X">CELL"Y",CELL"X",CELL"Y") and the most complicated
manipulation would deleting columns or cell with values like
=CELL"X"... Nothing to complicated.....

Hopefully this will help some...

Signature

mseifert_99

Reply to this Message

LeAnne - 18 Jan 2006 17:06 GMT

Hmm...helped some, but I'm still somewhat baffled. See comments inline.

> Ok let see if I can answer some of this...
>
> The command button... The command button would be in Access to open the
> Excel spreadsheet that has the marco/procedure to manipulate the
> data...

With you so far...you want Access to open a particular spreadsheet file
containing a previously-recorded macro/procedure.

> The file to be manipulated would be a Different Excel Spreadsheet each
> time.. The spreadsheet would be coming from a piece of test equipment
> that outputs the results data in spreadsheet format....

This is confusing. You mean you want to open a different workbook than
the one containing the macro? And you want to be able to dynamically
choose which spreadsheet to open?

So I would need

> soemthing like a Excel add-in file....

By "add-in file," do you mean you want to create a supplemental program
with custom features? What kind?

> The calculation/and manipulation would not be anything complicated...
> An example of the calculation would be something
> =max(abs(CELL"X":CELL"Y") or maybe a
> IF(CELL"X">CELL"Y",CELL"X",CELL"Y") and the most complicated
> manipulation would deleting columns or cell with values like
> =CELL"X"... Nothing to complicated.....

As you say, these are not complex formulas and could easily be done in
an Access query as well as in Excel.

Perhaps I'm not understanding you correctly. Could you elucidate?

LeAnne

Reply to this Message