Import Access Table into Excel. I appreciate your assistance. Thanks!

I have a table in Access called "Invested Related". All the analysis
is to be done in Excel.

I want to implement a button in EXCEL. Such that when the user clicks
on it, it will go to Access get that Table and then paste it in the
current workbook.

Then when it's pasted in Excel (there are about 10 Categories), I want
the categories to be sorted using the category called "Invested". So
Basically, only show me columns for "Invested."

Is there anyway this can be done in Excel?

I greatly appreciate your efforts, guys!

Thanks!

Hi Damil4real

Maybe this page will help
http://www.rondebruin.nl/accessexcel.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Damil4real" wrote in message ...
I have a table in Access called "Invested Related". All the analysis
is to be done in Excel.

I want to implement a button in EXCEL. Such that when the user clicks
on it, it will go to Access get that Table and then paste it in the
current workbook.

Then when it's pasted in Excel (there are about 10 Categories), I want
the categories to be sorted using the category called "Invested". So
Basically, only show me columns for "Invested."

Is there anyway this can be done in Excel?

I greatly appreciate your efforts, guys!

Thanks!

On Sep 11, 2:13*pm, "Ron de Bruin" wrote:
Hi Damil4real

Maybe this page will helphttp://www.rondebruin.nl/accessexcel.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Damil4real" wrote in ...
I have a table in Access called "Invested Related". All the analysis
is to be done in Excel.

I want to implement a button in EXCEL. Such that when the user clicks
on it, it will go to Access get that Table and then paste it in the
current workbook.

Then when it's pasted in Excel (there are about 10 Categories), I want
the categories to be sorted using the category called "Invested". So
Basically, only show me columns for "Invested."

Is there anyway this can be done in Excel?

I greatly appreciate your efforts, guys!

Thanks!- Hide quoted text -

- Show quoted text -

Thanks! I visited that page, and I tried all of the codes, but none
worked. I received errors on them all.

I appreciate any assistance.

Thanks!

That's interesting

What kind of errors ?
Which Excel version do you use ?


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Damil4real" wrote in message ...
On Sep 11, 2:13 pm, "Ron de Bruin" wrote:
Hi Damil4real

Maybe this page will helphttp://www.rondebruin.nl/accessexcel.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Damil4real" wrote in ...
I have a table in Access called "Invested Related". All the analysis
is to be done in Excel.

I want to implement a button in EXCEL. Such that when the user clicks
on it, it will go to Access get that Table and then paste it in the
current workbook.

Then when it's pasted in Excel (there are about 10 Categories), I want
the categories to be sorted using the category called "Invested". So
Basically, only show me columns for "Invested."

Is there anyway this can be done in Excel?

I greatly appreciate your efforts, guys!

Thanks!- Hide quoted text -

- Show quoted text -

Thanks! I visited that page, and I tried all of the codes, but none
worked. I received errors on them all.

I appreciate any assistance.

Thanks!

On Sep 11, 3:08*pm, "Ron de Bruin" wrote:
That's interesting

What kind of errors ?
Which Excel version do you use ?

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Damil4real" wrote in ...

On Sep 11, 2:13 pm, "Ron de Bruin" wrote:





Hi Damil4real

Maybe this page will helphttp://www.rondebruin.nl/accessexcel.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Damil4real" wrote in ...
I have a table in Access called "Invested Related". All the analysis
is to be done in Excel.

I want to implement a button in EXCEL. Such that when the user clicks
on it, it will go to Access get that Table and then paste it in the
current workbook.

Then when it's pasted in Excel (there are about 10 Categories), I want
the categories to be sorted using the category called "Invested". So
Basically, only show me columns for "Invested."

Is there anyway this can be done in Excel?

I greatly appreciate your efforts, guys!

Thanks!- Hide quoted text -

- Show quoted text -

Thanks! I visited that page, and I tried all of the codes, but none
worked. I received errors on them all.

I appreciate any assistance.

Thanks!- Hide quoted text -

- Show quoted text -


Version 2003.

Error says: "Compile error: Sub or Function not defined"

Then Sub Test1() is highlighted.

I ended the suggested code as follows:

Sub Test1()
'This example retrieves the data for the records in which ShipCountry
= Germany
GetDataFromAccess ThisWorkbook.Path & "/access file name.mdb",
"table name", _
"XX", "=", "XX", _
Sheets("Book4").Range("A8"), _
"*", True, True
End Sub


Code didn't work.

Thanks for your help!

Did you download my examples ?

I think you only copy the small macro
Test the download first


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Damil4real" wrote in message ...
On Sep 11, 3:08 pm, "Ron de Bruin" wrote:
That's interesting

What kind of errors ?
Which Excel version do you use ?

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Damil4real" wrote in ...

On Sep 11, 2:13 pm, "Ron de Bruin" wrote:





Hi Damil4real

Maybe this page will helphttp://www.rondebruin.nl/accessexcel.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Damil4real" wrote in ...
I have a table in Access called "Invested Related". All the analysis
is to be done in Excel.

I want to implement a button in EXCEL. Such that when the user clicks
on it, it will go to Access get that Table and then paste it in the
current workbook.

Then when it's pasted in Excel (there are about 10 Categories), I want
the categories to be sorted using the category called "Invested". So
Basically, only show me columns for "Invested."

Is there anyway this can be done in Excel?

I greatly appreciate your efforts, guys!

Thanks!- Hide quoted text -

- Show quoted text -

Thanks! I visited that page, and I tried all of the codes, but none
worked. I received errors on them all.

I appreciate any assistance.

Thanks!- Hide quoted text -

- Show quoted text -


Version 2003.

Error says: "Compile error: Sub or Function not defined"

Then Sub Test1() is highlighted.

I ended the suggested code as follows:

Sub Test1()
'This example retrieves the data for the records in which ShipCountry
= Germany
GetDataFromAccess ThisWorkbook.Path & "/access file name.mdb",
"table name", _
"XX", "=", "XX", _
Sheets("Book4").Range("A8"), _
"*", True, True
End Sub


Code didn't work.

Thanks for your help!

On Sep 11, 3:23*pm, "Ron de Bruin" wrote:
Did you download my examples ?

I think you only copy the small macro
Test the download first

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Damil4real" wrote in ...

On Sep 11, 3:08 pm, "Ron de Bruin" wrote:





That's interesting

What kind of errors ?
Which Excel version do you use ?

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Damil4real" wrote in ...

On Sep 11, 2:13 pm, "Ron de Bruin" wrote:

Hi Damil4real

Maybe this page will helphttp://www.rondebruin.nl/accessexcel.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Damil4real" wrote in ...
I have a table in Access called "Invested Related". All the analysis
is to be done in Excel.

I want to implement a button in EXCEL. Such that when the user clicks
on it, it will go to Access get that Table and then paste it in the
current workbook.

Then when it's pasted in Excel (there are about 10 Categories), I want
the categories to be sorted using the category called "Invested". So
Basically, only show me columns for "Invested."

Is there anyway this can be done in Excel?

I greatly appreciate your efforts, guys!

Thanks!- Hide quoted text -

- Show quoted text -

Thanks! I visited that page, and I tried all of the codes, but none
worked. I received errors on them all.

I appreciate any assistance.

Thanks!- Hide quoted text -

- Show quoted text -

Version 2003.

Error says: "Compile error: Sub or Function not defined"

Then Sub Test1() is highlighted.

I ended the suggested code as follows:

Sub Test1()
'This example retrieves the data for the records in which ShipCountry
= Germany
* * GetDataFromAccess ThisWorkbook.Path & "/access file name.mdb",
"table name", _
* * * * * * * * * * * "XX", "=", "XX", _
* * * * * * * * * * * Sheets("Book4").Range("A8"), _
* * * * * * * * * * * "*", True, True
End Sub

Code didn't work.

Thanks for your help!- Hide quoted text -

- Show quoted text -

I greatly appreciate your assistance, Ron, but the code is still not
working.

I downloaded and made some changes to your code, but it's still not
working. I get an error message that says: "error copying data." I
don't know why I'm getting this error. It seems your example has the
table name as just one word ("Orders"), while my table has two words
("Invested Related"). Also my access path has three words.

Also you have ur path as: GetDataFromAccess ThisWorkbook.Path & "/
OrderDatabase.mdb", "Orders", _

I changed this code to my path..something like:

GetDataFromAccess ThisWorkbook.Path & "/Invested Related.mdb",
"Invested Securities", _

OR

GetDataFromAccess ThisWorkbook.Path & "C:xxx/xxx/xxx/
OrderDatabase.mdb", "Invested Securities", _

OR

GetDataFromAccess ThisWorkbook.Path & "C:xxx\xxx\xxx
\OrderDatabase.mdb", "Invested Securities", _

Any difference in having \ or /?

It seems like the path code is not working well.

Thanks for your help!

Hi

This is not correct

GetDataFromAccess ThisWorkbook.Path & "C:xxx/xxx/xxx/
OrderDatabase.mdb", "Invested Securities", _


Remove this

ThisWorkbook.Path &


And enter your path like this "C:\Users\Ron\test\OrderDatabase.mdb"


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Damil4real" wrote in message ...
On Sep 11, 3:23 pm, "Ron de Bruin" wrote:
Did you download my examples ?

I think you only copy the small macro
Test the download first

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Damil4real" wrote in ...

On Sep 11, 3:08 pm, "Ron de Bruin" wrote:





That's interesting

What kind of errors ?
Which Excel version do you use ?

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Damil4real" wrote in ...

On Sep 11, 2:13 pm, "Ron de Bruin" wrote:

Hi Damil4real

Maybe this page will helphttp://www.rondebruin.nl/accessexcel.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Damil4real" wrote in ...
I have a table in Access called "Invested Related". All the analysis
is to be done in Excel.

I want to implement a button in EXCEL. Such that when the user clicks
on it, it will go to Access get that Table and then paste it in the
current workbook.

Then when it's pasted in Excel (there are about 10 Categories), I want
the categories to be sorted using the category called "Invested". So
Basically, only show me columns for "Invested."

Is there anyway this can be done in Excel?

I greatly appreciate your efforts, guys!

Thanks!- Hide quoted text -

- Show quoted text -

Thanks! I visited that page, and I tried all of the codes, but none
worked. I received errors on them all.

I appreciate any assistance.

Thanks!- Hide quoted text -

- Show quoted text -

Version 2003.

Error says: "Compile error: Sub or Function not defined"

Then Sub Test1() is highlighted.

I ended the suggested code as follows:

Sub Test1()
'This example retrieves the data for the records in which ShipCountry
= Germany
GetDataFromAccess ThisWorkbook.Path & "/access file name.mdb",
"table name", _
"XX", "=", "XX", _
Sheets("Book4").Range("A8"), _
"*", True, True
End Sub

Code didn't work.

Thanks for your help!- Hide quoted text -

- Show quoted text -

I greatly appreciate your assistance, Ron, but the code is still not
working.

I downloaded and made some changes to your code, but it's still not
working. I get an error message that says: "error copying data." I
don't know why I'm getting this error. It seems your example has the
table name as just one word ("Orders"), while my table has two words
("Invested Related"). Also my access path has three words.

Also you have ur path as: GetDataFromAccess ThisWorkbook.Path & "/
OrderDatabase.mdb", "Orders", _

I changed this code to my path..something like:

GetDataFromAccess ThisWorkbook.Path & "/Invested Related.mdb",
"Invested Securities", _

OR

GetDataFromAccess ThisWorkbook.Path & "C:xxx/xxx/xxx/
OrderDatabase.mdb", "Invested Securities", _

OR

GetDataFromAccess ThisWorkbook.Path & "C:xxx\xxx\xxx
\OrderDatabase.mdb", "Invested Securities", _

Any difference in having \ or /?

It seems like the path code is not working well.

Thanks for your help!

On Sep 12, 10:27*am, "Ron de Bruin" wrote:
Hi

This is not correct

GetDataFromAccess ThisWorkbook.Path & "C:xxx/xxx/xxx/
OrderDatabase.mdb", "Invested Securities", _

Remove this

ThisWorkbook.Path &

And enter your path like this "C:\Users\Ron\test\OrderDatabase.mdb"

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Damil4real" wrote in ...

On Sep 11, 3:23 pm, "Ron de Bruin" wrote:





Did you download my examples ?

I think you only copy the small macro
Test the download first

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Damil4real" wrote in ...

On Sep 11, 3:08 pm, "Ron de Bruin" wrote:

That's interesting

What kind of errors ?
Which Excel version do you use ?

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Damil4real" wrote in ...

On Sep 11, 2:13 pm, "Ron de Bruin" wrote:

Hi Damil4real

Maybe this page will helphttp://www.rondebruin.nl/accessexcel.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Damil4real" wrote in ...
I have a table in Access called "Invested Related". All the analysis
is to be done in Excel.

I want to implement a button in EXCEL. Such that when the user clicks
on it, it will go to Access get that Table and then paste it in the
current workbook.

Then when it's pasted in Excel (there are about 10 Categories), I want
the categories to be sorted using the category called "Invested". So
Basically, only show me columns for "Invested."

Is there anyway this can be done in Excel?

I greatly appreciate your efforts, guys!

Thanks!- Hide quoted text -

- Show quoted text -

Thanks! I visited that page, and I tried all of the codes, but none
worked. I received errors on them all.

I appreciate any assistance.

Thanks!- Hide quoted text -

- Show quoted text -

Version 2003.

Error says: "Compile error: Sub or Function not defined"

Then Sub Test1() is highlighted.

I ended the suggested code as follows:

Sub Test1()
'This example retrieves the data for the records in which ShipCountry
= Germany
GetDataFromAccess ThisWorkbook.Path & "/access file name.mdb",
"table name", _
"XX", "=", "XX", _
Sheets("Book4").Range("A8"), _
"*", True, True
End Sub

Code didn't work.

Thanks for your help!- Hide quoted text -

- Show quoted text -

I greatly appreciate your assistance, Ron, but the code is still not
working.

I downloaded and made some changes to your code, but it's still not
working. I get an error message that says: "error copying data." I
don't know why I'm getting this error. It seems your example has the
table name as just one word ("Orders"), while my table has two words
("Invested Related"). Also my access path has three words.

Also you have ur path as: GetDataFromAccess ThisWorkbook.Path & "/
OrderDatabase.mdb", "Orders", _

I changed this code to my path..something like:

GetDataFromAccess ThisWorkbook.Path & "/Invested Related.mdb",
"Invested Securities", _

OR

GetDataFromAccess ThisWorkbook.Path & "C:xxx/xxx/xxx/
OrderDatabase.mdb", "Invested Securities", _

OR

GetDataFromAccess ThisWorkbook.Path & "C:xxx\xxx\xxx
\OrderDatabase.mdb", "Invested Securities", _

Any difference in having \ or /?

It seems like the path code is not working well.

Thanks for your help!- Hide quoted text -

- Show quoted text -

Ron, on my access table the name of my categories are two letter words
like "invested securities" or "Cusip Number"...etc. I see that yours
is merged together like "OrderNumber" "ShipVia" "ShipCountry"...etc.
Does that make a difference? This categories in Access is shown as two
or three-letter words.

My Access File Name is "invested securities.mdb" while yours is
"OrderDatabase.mdb" So everytime I saw the "OrderDatabase.mdb" I
changed it to "invested securities.mdb. I tried merging it, but still
no luck.

My Access Table Name is "invested companies" while yours is "Orders"
So everytime I saw "Order", I changed it to "invested companies" I
tried merging this as well to fit yours, but still no luck.

Now is the space betwee all these two or three-letter words a problem?
Because I entered the path code just as you suggested, but still no
luck.

I apologize for bothering you so often, but I do appreciate your
patience and assistance.

Thanks!

Hi Damil4real

Send me your database private
I will look at it then for you

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Damil4real" wrote in message ...
On Sep 12, 10:27 am, "Ron de Bruin" wrote:
Hi

This is not correct

GetDataFromAccess ThisWorkbook.Path & "C:xxx/xxx/xxx/
OrderDatabase.mdb", "Invested Securities", _

Remove this

ThisWorkbook.Path &

And enter your path like this "C:\Users\Ron\test\OrderDatabase.mdb"

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Damil4real" wrote in ...

On Sep 11, 3:23 pm, "Ron de Bruin" wrote:





Did you download my examples ?

I think you only copy the small macro
Test the download first

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Damil4real" wrote in ...

On Sep 11, 3:08 pm, "Ron de Bruin" wrote:

That's interesting

What kind of errors ?
Which Excel version do you use ?

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Damil4real" wrote in ...

On Sep 11, 2:13 pm, "Ron de Bruin" wrote:

Hi Damil4real

Maybe this page will helphttp://www.rondebruin.nl/accessexcel.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"Damil4real" wrote in
...
I have a table in Access called "Invested Related". All the analysis
is to be done in Excel.

I want to implement a button in EXCEL. Such that when the user clicks
on it, it will go to Access get that Table and then paste it in the
current workbook.

Then when it's pasted in Excel (there are about 10 Categories), I want
the categories to be sorted using the category called "Invested". So
Basically, only show me columns for "Invested."

Is there anyway this can be done in Excel?

I greatly appreciate your efforts, guys!

Thanks!- Hide quoted text -

- Show quoted text -

Thanks! I visited that page, and I tried all of the codes, but none
worked. I received errors on them all.

I appreciate any assistance.

Thanks!- Hide quoted text -

- Show quoted text -

Version 2003.

Error says: "Compile error: Sub or Function not defined"

Then Sub Test1() is highlighted.

I ended the suggested code as follows:

Sub Test1()
'This example retrieves the data for the records in which ShipCountry
= Germany
GetDataFromAccess ThisWorkbook.Path & "/access file name.mdb",
"table name", _
"XX", "=", "XX", _
Sheets("Book4").Range("A8"), _
"*", True, True
End Sub

Code didn't work.

Thanks for your help!- Hide quoted text -

- Show quoted text -

I greatly appreciate your assistance, Ron, but the code is still not
working.

I downloaded and made some changes to your code, but it's still not
working. I get an error message that says: "error copying data." I
don't know why I'm getting this error. It seems your example has the
table name as just one word ("Orders"), while my table has two words
("Invested Related"). Also my access path has three words.

Also you have ur path as: GetDataFromAccess ThisWorkbook.Path & "/
OrderDatabase.mdb", "Orders", _

I changed this code to my path..something like:

GetDataFromAccess ThisWorkbook.Path & "/Invested Related.mdb",
"Invested Securities", _

OR

GetDataFromAccess ThisWorkbook.Path & "C:xxx/xxx/xxx/
OrderDatabase.mdb", "Invested Securities", _

OR

GetDataFromAccess ThisWorkbook.Path & "C:xxx\xxx\xxx
\OrderDatabase.mdb", "Invested Securities", _

Any difference in having \ or /?

It seems like the path code is not working well.

Thanks for your help!- Hide quoted text -

- Show quoted text -

Ron, on my access table the name of my categories are two letter words
like "invested securities" or "Cusip Number"...etc. I see that yours
is merged together like "OrderNumber" "ShipVia" "ShipCountry"...etc.
Does that make a difference? This categories in Access is shown as two
or three-letter words.

My Access File Name is "invested securities.mdb" while yours is
"OrderDatabase.mdb" So everytime I saw the "OrderDatabase.mdb" I
changed it to "invested securities.mdb. I tried merging it, but still
no luck.

My Access Table Name is "invested companies" while yours is "Orders"
So everytime I saw "Order", I changed it to "invested companies" I
tried merging this as well to fit yours, but still no luck.

Now is the space betwee all these two or three-letter words a problem?
Because I entered the path code just as you suggested, but still no
luck.

I apologize for bothering you so often, but I do appreciate your
patience and assistance.

Thanks!