Re: [MSAccessProfessionals] Import XML file

hi Valentino,

"working and stable" is great!!

kind regards,
crystal

On 8/6/2023 1:26 AM, avvisati wrote:

Hi Crystal,

Yes at the end is what I did: procedure that open the excel and import in access in recursive way. Is working and stable.

I'm sure that can be done better learning more,  but at the end as  the poet Bertolt Brecht wrote  it is true that in some cases  "the shortest distance between two points can be a curve."

If one super expert as you is also suggesting this,  mean that is really true …

Valentino

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Tuesday, August 1, 2023 8:08 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Import XML file

 

hi Valentino,

Maybe use Excel to get the XML and then refresh and link from Access? One of the powerful things about Access is its ability to leverage other products. Excel may have better XML interpretation capabilities than Access does at the moment ...

kind regards,
crystal

On 1/08/2023 8:11 am, avvisati wrote:

Hello Chrystal,

Yes could be, but I do not have it, what I should do is simply take some data from these XML.

I'm not interested to put this data in different access table, just import in similar way as we get when we open with excel in a  table,  and after work selectively in some of these data.

Honestly I created an application in access that is opening the excel that is connected to the XML, is refreshing the file, and is importing the excel the data from excel.

Not really a linear and elegant way but works…

I would have liked directly import some of the information from XML, avoiding excel in the middle

Whatever suggestion is well accepted

 

Valentino

 

 

 

 

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Monday, July 31, 2023 5:45 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Import XML file

 

Valentino, there is probably also an XML header file but you didn't specify that -- do you have one? Excel brings everything in as flat data whereas Access should separate data into different tables. This isn't an easy task!

kind regards,
crystal

On 29/07/2023 4:20 am, avvisati wrote:

 

Yes I understand this, this is why I asked for help since I'm not an expert

I know that there are two ways to go on:

 

1. Transform the XML from attribute centric like this one  to element centric using xls language- file

And transform from an XML as this one  

 

<person sex="female">

  <firstname>Anna</firstname>

  <lastname>Smith</lastname>

</person>

 

Try to get something like this one

<person>

  <sex>female</sex>

  <firstname>Anna</firstname>

  <lastname>Smith</lastname>

</person>

And after import because the Element centric is compatible with Access

 

 

2. The other way is read informatio using VBA, and I wanted to try this

I tried  to google and try to get some example like this one

But I do not succeded  to get the information, or better I can  I can retrive some informaton but but

 

This is why  I ask support of somebody can give some preatical indicatoin where to see

 

 

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Arnelito Puzon
Sent: Saturday, July 29, 2023 5:02 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Import XML file

 

it is obvious that the xml file is not a well-formed access xml file so it is

not being imported. you need special VBA to create a structure for those

fields in your xml.

 

On Sat, Jul 15, 2023 at 5:25 PM avvisati <valentino.avvisati@gmail.com> wrote:

Hello All, 

i need to import one XML file to access, I can open it with no problem in excel and after import but I would like to import directly in Access 

The problem is that when I import using the XML importation of Access, are created some table but empty and I understand  probably the problem is that the file I want to open,  is based on attribute but should be based on element 

I also read that I first should transform the file to a Element based file and after i can import. 

I tried  to creatine xsl file but with no success 

somebody can give me some indication and eventually suggest some tool?

I do not know XML 

thank you 

Valentino 

 

 

Re: [MSAccessProfessionals] Import XML file

Hi Crystal,

Yes at the end is what I did: procedure that open the excel and import in access in recursive way. Is working and stable.

I'm sure that can be done better learning more,  but at the end as  the poet Bertolt Brecht wrote  it is true that in some cases  "the shortest distance between two points can be a curve."

If one super expert as you is also suggesting this,  mean that is really true …

Valentino

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Tuesday, August 1, 2023 8:08 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Import XML file

 

hi Valentino,

Maybe use Excel to get the XML and then refresh and link from Access? One of the powerful things about Access is its ability to leverage other products. Excel may have better XML interpretation capabilities than Access does at the moment ...

kind regards,
crystal

On 1/08/2023 8:11 am, avvisati wrote:

Hello Chrystal,

Yes could be, but I do not have it, what I should do is simply take some data from these XML.

I'm not interested to put this data in different access table, just import in similar way as we get when we open with excel in a  table,  and after work selectively in some of these data.

Honestly I created an application in access that is opening the excel that is connected to the XML, is refreshing the file, and is importing the excel the data from excel.

Not really a linear and elegant way but works…

I would have liked directly import some of the information from XML, avoiding excel in the middle

Whatever suggestion is well accepted

 

Valentino

 

 

 

 

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Monday, July 31, 2023 5:45 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Import XML file

 

Valentino, there is probably also an XML header file but you didn't specify that -- do you have one? Excel brings everything in as flat data whereas Access should separate data into different tables. This isn't an easy task!

kind regards,
crystal

On 29/07/2023 4:20 am, avvisati wrote:

 

Yes I understand this, this is why I asked for help since I'm not an expert

I know that there are two ways to go on:

 

1. Transform the XML from attribute centric like this one  to element centric using xls language- file

And transform from an XML as this one  

 

<person sex="female">

  <firstname>Anna</firstname>

  <lastname>Smith</lastname>

</person>

 

Try to get something like this one

<person>

  <sex>female</sex>

  <firstname>Anna</firstname>

  <lastname>Smith</lastname>

</person>

And after import because the Element centric is compatible with Access

 

 

2. The other way is read informatio using VBA, and I wanted to try this

I tried  to google and try to get some example like this one

But I do not succeded  to get the information, or better I can  I can retrive some informaton but but

 

This is why  I ask support of somebody can give some preatical indicatoin where to see

 

 

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Arnelito Puzon
Sent: Saturday, July 29, 2023 5:02 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Import XML file

 

it is obvious that the xml file is not a well-formed access xml file so it is

not being imported. you need special VBA to create a structure for those

fields in your xml.

 

On Sat, Jul 15, 2023 at 5:25 PM avvisati <valentino.avvisati@gmail.com> wrote:

Hello All, 

i need to import one XML file to access, I can open it with no problem in excel and after import but I would like to import directly in Access 

The problem is that when I import using the XML importation of Access, are created some table but empty and I understand  probably the problem is that the file I want to open,  is based on attribute but should be based on element 

I also read that I first should transform the file to a Element based file and after i can import. 

I tried  to creatine xsl file but with no success 

somebody can give me some indication and eventually suggest some tool?

I do not know XML 

thank you 

Valentino 

 

 

Re: [MSAccessProfessionals] Error while Linking Table from MySql to Ms.Access

Duane, appreciated. Somehow installing MySql ODBC connector 5.1 and using it instead of 8.1 resolves the issue.

best regards

Ahmed

On Wed, Aug 2, 2023 at 4:14 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Next, I would try select a single, simple field in a pass-through rather than all fields. 

Duane

Sent from my mobile

On Aug 2, 2023, at 12:23 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Yes, a simple table with just 2 field and few data, is connected via pass through query without any errors.

regards

Ahmed

On Tue, Aug 1, 2023 at 11:07 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Did you try with a very simple table?

Duane

On Aug 1, 2023, at 1:01 PM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Duane

I think now i understand what you meant, tried the pass through query with ODBC connection string:

<image.png>

tried both File DSN and Machine DSN with same following error:

<image.png>

regards

Ahmed

On Tue, Aug 1, 2023 at 10:42 PM Ahmed Hashim via groups.io <ahmedhashim1=gmail.com@groups.io> wrote:

Duane,

How do I create a pass through query from Ms.Access without connecting/Linking to MySql? I am trying to link with only 1 table. With no relationship with any other tables etc.

regards

Ahmed

On Tue, Aug 1, 2023 at 10:40 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Did you attempt the pass-through query in Access? There might be an incompatibility issue with one or more fields. Can you try link to a very simple table?

Duane

On Aug 1, 2023, at 10:24 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Duane,

Surprisingly Excel is able to get connected with MySql and even import data via ODBC without any errors.

regards

Ahmed

On Tue, Aug 1, 2023 at 6:27 PM Duane Hookom <duanehookom@hotmail.com> wrote:

I would try create a pass-through query or connect via Excel (as tests). 

Duane

Sent from my mobile

On Aug 1, 2023, at 7:47 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Yes, creating DSN outside Ms.Access is successfully connected with MySql database:

<image.png>

On Tue, Aug 1, 2023 at 4:59 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Creating an ODBC/DSN can be accomplished completely outside of Access. Is this successful? Will the DSN connect?

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Ahmed Hashim <ahmedhashim1@gmail.com>
Sent: Tuesday, August 1, 2023 12:52 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Error while Linking Table from MySql to Ms.Access

 

Hi to All,

I am trying to connect and link Mysql table with Ms.Access, but everytime using wizard it shows following error:

<image.png>

I've tried via ODBC (file, system and machine DSN), and received the same error every time.

Environment Information:

Windows 10 64bit

Ms. Office version 2019 64bit

MySql version: mysql  Ver 15.1 Distrib 10.4.20-MariaDB, for Win64 (AMD64), source revision c7ee039d36f69f24fb3b1c422fcff8dbf974e3eb

MySql ODBC Driver/Connector: MySQL ODBC 8.1

Any help/suggestion will be highly appreciated.

best regards

Ahmed Hashim

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116432) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Re: [MSAccessProfessionals] Error while Linking Table from MySql to Ms.Access

Next, I would try select a single, simple field in a pass-through rather than all fields. 

Duane

Sent from my mobile

On Aug 2, 2023, at 12:23 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Yes, a simple table with just 2 field and few data, is connected via pass through query without any errors.

regards

Ahmed

On Tue, Aug 1, 2023 at 11:07 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Did you try with a very simple table?

Duane

On Aug 1, 2023, at 1:01 PM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Duane

I think now i understand what you meant, tried the pass through query with ODBC connection string:

<image.png>

tried both File DSN and Machine DSN with same following error:

<image.png>

regards

Ahmed

On Tue, Aug 1, 2023 at 10:42 PM Ahmed Hashim via groups.io <ahmedhashim1=gmail.com@groups.io> wrote:

Duane,

How do I create a pass through query from Ms.Access without connecting/Linking to MySql? I am trying to link with only 1 table. With no relationship with any other tables etc.

regards

Ahmed

On Tue, Aug 1, 2023 at 10:40 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Did you attempt the pass-through query in Access? There might be an incompatibility issue with one or more fields. Can you try link to a very simple table?

Duane

On Aug 1, 2023, at 10:24 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Duane,

Surprisingly Excel is able to get connected with MySql and even import data via ODBC without any errors.

regards

Ahmed

On Tue, Aug 1, 2023 at 6:27 PM Duane Hookom <duanehookom@hotmail.com> wrote:

I would try create a pass-through query or connect via Excel (as tests). 

Duane

Sent from my mobile

On Aug 1, 2023, at 7:47 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Yes, creating DSN outside Ms.Access is successfully connected with MySql database:

<image.png>

On Tue, Aug 1, 2023 at 4:59 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Creating an ODBC/DSN can be accomplished completely outside of Access. Is this successful? Will the DSN connect?

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Ahmed Hashim <ahmedhashim1@gmail.com>
Sent: Tuesday, August 1, 2023 12:52 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Error while Linking Table from MySql to Ms.Access

 

Hi to All,

I am trying to connect and link Mysql table with Ms.Access, but everytime using wizard it shows following error:

<image.png>

I've tried via ODBC (file, system and machine DSN), and received the same error every time.

Environment Information:

Windows 10 64bit

Ms. Office version 2019 64bit

MySql version: mysql  Ver 15.1 Distrib 10.4.20-MariaDB, for Win64 (AMD64), source revision c7ee039d36f69f24fb3b1c422fcff8dbf974e3eb

MySql ODBC Driver/Connector: MySQL ODBC 8.1

Any help/suggestion will be highly appreciated.

best regards

Ahmed Hashim

Re: [MSAccessProfessionals] Error while Linking Table from MySql to Ms.Access

Yes, a simple table with just 2 field and few data, is connected via pass through query without any errors.

regards

Ahmed

On Tue, Aug 1, 2023 at 11:07 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Did you try with a very simple table?

Duane

On Aug 1, 2023, at 1:01 PM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Duane

I think now i understand what you meant, tried the pass through query with ODBC connection string:

<image.png>

tried both File DSN and Machine DSN with same following error:

<image.png>

regards

Ahmed

On Tue, Aug 1, 2023 at 10:42 PM Ahmed Hashim via groups.io <ahmedhashim1=gmail.com@groups.io> wrote:

Duane,

How do I create a pass through query from Ms.Access without connecting/Linking to MySql? I am trying to link with only 1 table. With no relationship with any other tables etc.

regards

Ahmed

On Tue, Aug 1, 2023 at 10:40 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Did you attempt the pass-through query in Access? There might be an incompatibility issue with one or more fields. Can you try link to a very simple table?

Duane

On Aug 1, 2023, at 10:24 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Duane,

Surprisingly Excel is able to get connected with MySql and even import data via ODBC without any errors.

regards

Ahmed

On Tue, Aug 1, 2023 at 6:27 PM Duane Hookom <duanehookom@hotmail.com> wrote:

I would try create a pass-through query or connect via Excel (as tests). 

Duane

Sent from my mobile

On Aug 1, 2023, at 7:47 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Yes, creating DSN outside Ms.Access is successfully connected with MySql database:

<image.png>

On Tue, Aug 1, 2023 at 4:59 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Creating an ODBC/DSN can be accomplished completely outside of Access. Is this successful? Will the DSN connect?

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Ahmed Hashim <ahmedhashim1@gmail.com>
Sent: Tuesday, August 1, 2023 12:52 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Error while Linking Table from MySql to Ms.Access

 

Hi to All,

I am trying to connect and link Mysql table with Ms.Access, but everytime using wizard it shows following error:

<image.png>

I've tried via ODBC (file, system and machine DSN), and received the same error every time.

Environment Information:

Windows 10 64bit

Ms. Office version 2019 64bit

MySql version: mysql  Ver 15.1 Distrib 10.4.20-MariaDB, for Win64 (AMD64), source revision c7ee039d36f69f24fb3b1c422fcff8dbf974e3eb

MySql ODBC Driver/Connector: MySQL ODBC 8.1

Any help/suggestion will be highly appreciated.

best regards

Ahmed Hashim

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116430) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Re: [MSAccessProfessionals] Import XML file

hi Valentino,

Maybe use Excel to get the XML and then refresh and link from Access? One of the powerful things about Access is its ability to leverage other products. Excel may have better XML interpretation capabilities than Access does at the moment ...

kind regards,
crystal

On 1/08/2023 8:11 am, avvisati wrote:

Hello Chrystal,

Yes could be, but I do not have it, what I should do is simply take some data from these XML.

I'm not interested to put this data in different access table, just import in similar way as we get when we open with excel in a  table,  and after work selectively in some of these data.

Honestly I created an application in access that is opening the excel that is connected to the XML, is refreshing the file, and is importing the excel the data from excel.

Not really a linear and elegant way but works…

I would have liked directly import some of the information from XML, avoiding excel in the middle

Whatever suggestion is well accepted

 

Valentino

 

 

 

 

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Monday, July 31, 2023 5:45 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Import XML file

 

Valentino, there is probably also an XML header file but you didn't specify that -- do you have one? Excel brings everything in as flat data whereas Access should separate data into different tables. This isn't an easy task!

kind regards,
crystal

On 29/07/2023 4:20 am, avvisati wrote:

 

Yes I understand this, this is why I asked for help since I'm not an expert

I know that there are two ways to go on:

 

1. Transform the XML from attribute centric like this one  to element centric using xls language- file

And transform from an XML as this one  

 

<person sex="female">

  <firstname>Anna</firstname>

  <lastname>Smith</lastname>

</person>

 

Try to get something like this one

<person>

  <sex>female</sex>

  <firstname>Anna</firstname>

  <lastname>Smith</lastname>

</person>

And after import because the Element centric is compatible with Access

 

 

2. The other way is read informatio using VBA, and I wanted to try this

I tried  to google and try to get some example like this one

But I do not succeded  to get the information, or better I can  I can retrive some informaton but but

 

This is why  I ask support of somebody can give some preatical indicatoin where to see

 

 

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Arnelito Puzon
Sent: Saturday, July 29, 2023 5:02 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Import XML file

 

it is obvious that the xml file is not a well-formed access xml file so it is

not being imported. you need special VBA to create a structure for those

fields in your xml.

 

On Sat, Jul 15, 2023 at 5:25 PM avvisati <valentino.avvisati@gmail.com> wrote:

Hello All, 

i need to import one XML file to access, I can open it with no problem in excel and after import but I would like to import directly in Access 

The problem is that when I import using the XML importation of Access, are created some table but empty and I understand  probably the problem is that the file I want to open,  is based on attribute but should be based on element 

I also read that I first should transform the file to a Element based file and after i can import. 

I tried  to creatine xsl file but with no success 

somebody can give me some indication and eventually suggest some tool?

I do not know XML 

thank you 

Valentino 

 

 

Re: [MSAccessProfessionals] Error while Linking Table from MySql to Ms.Access

Did you try with a very simple table?

Duane

On Aug 1, 2023, at 1:01 PM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Duane

I think now i understand what you meant, tried the pass through query with ODBC connection string:

<image.png>

tried both File DSN and Machine DSN with same following error:

<image.png>

regards

Ahmed

On Tue, Aug 1, 2023 at 10:42 PM Ahmed Hashim via groups.io <ahmedhashim1=gmail.com@groups.io> wrote:

Duane,

How do I create a pass through query from Ms.Access without connecting/Linking to MySql? I am trying to link with only 1 table. With no relationship with any other tables etc.

regards

Ahmed

On Tue, Aug 1, 2023 at 10:40 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Did you attempt the pass-through query in Access? There might be an incompatibility issue with one or more fields. Can you try link to a very simple table?

Duane

On Aug 1, 2023, at 10:24 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Duane,

Surprisingly Excel is able to get connected with MySql and even import data via ODBC without any errors.

regards

Ahmed

On Tue, Aug 1, 2023 at 6:27 PM Duane Hookom <duanehookom@hotmail.com> wrote:

I would try create a pass-through query or connect via Excel (as tests). 

Duane

Sent from my mobile

On Aug 1, 2023, at 7:47 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Yes, creating DSN outside Ms.Access is successfully connected with MySql database:

<image.png>

On Tue, Aug 1, 2023 at 4:59 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Creating an ODBC/DSN can be accomplished completely outside of Access. Is this successful? Will the DSN connect?

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Ahmed Hashim <ahmedhashim1@gmail.com>
Sent: Tuesday, August 1, 2023 12:52 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Error while Linking Table from MySql to Ms.Access

 

Hi to All,

I am trying to connect and link Mysql table with Ms.Access, but everytime using wizard it shows following error:

<image.png>

I've tried via ODBC (file, system and machine DSN), and received the same error every time.

Environment Information:

Windows 10 64bit

Ms. Office version 2019 64bit

MySql version: mysql  Ver 15.1 Distrib 10.4.20-MariaDB, for Win64 (AMD64), source revision c7ee039d36f69f24fb3b1c422fcff8dbf974e3eb

MySql ODBC Driver/Connector: MySQL ODBC 8.1

Any help/suggestion will be highly appreciated.

best regards

Ahmed Hashim

Re: [MSAccessProfessionals] Error while Linking Table from MySql to Ms.Access

Duane

I think now i understand what you meant, tried the pass through query with ODBC connection string:

tried both File DSN and Machine DSN with same following error:

regards

Ahmed

On Tue, Aug 1, 2023 at 10:42 PM Ahmed Hashim via groups.io <ahmedhashim1=gmail.com@groups.io> wrote:

Duane,

How do I create a pass through query from Ms.Access without connecting/Linking to MySql? I am trying to link with only 1 table. With no relationship with any other tables etc.

regards

Ahmed

On Tue, Aug 1, 2023 at 10:40 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Did you attempt the pass-through query in Access? There might be an incompatibility issue with one or more fields. Can you try link to a very simple table?

Duane

On Aug 1, 2023, at 10:24 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Duane,

Surprisingly Excel is able to get connected with MySql and even import data via ODBC without any errors.

regards

Ahmed

On Tue, Aug 1, 2023 at 6:27 PM Duane Hookom <duanehookom@hotmail.com> wrote:

I would try create a pass-through query or connect via Excel (as tests). 

Duane

Sent from my mobile

On Aug 1, 2023, at 7:47 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Yes, creating DSN outside Ms.Access is successfully connected with MySql database:

<image.png>

On Tue, Aug 1, 2023 at 4:59 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Creating an ODBC/DSN can be accomplished completely outside of Access. Is this successful? Will the DSN connect?

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Ahmed Hashim <ahmedhashim1@gmail.com>
Sent: Tuesday, August 1, 2023 12:52 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Error while Linking Table from MySql to Ms.Access

 

Hi to All,

I am trying to connect and link Mysql table with Ms.Access, but everytime using wizard it shows following error:

<image.png>

I've tried via ODBC (file, system and machine DSN), and received the same error every time.

Environment Information:

Windows 10 64bit

Ms. Office version 2019 64bit

MySql version: mysql  Ver 15.1 Distrib 10.4.20-MariaDB, for Win64 (AMD64), source revision c7ee039d36f69f24fb3b1c422fcff8dbf974e3eb

MySql ODBC Driver/Connector: MySQL ODBC 8.1

Any help/suggestion will be highly appreciated.

best regards

Ahmed Hashim

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116427) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Re: [MSAccessProfessionals] Error while Linking Table from MySql to Ms.Access

Duane,

How do I create a pass through query from Ms.Access without connecting/Linking to MySql? I am trying to link with only 1 table. With no relationship with any other tables etc.

regards

Ahmed

On Tue, Aug 1, 2023 at 10:40 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Did you attempt the pass-through query in Access? There might be an incompatibility issue with one or more fields. Can you try link to a very simple table?

Duane

On Aug 1, 2023, at 10:24 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Duane,

Surprisingly Excel is able to get connected with MySql and even import data via ODBC without any errors.

regards

Ahmed

On Tue, Aug 1, 2023 at 6:27 PM Duane Hookom <duanehookom@hotmail.com> wrote:

I would try create a pass-through query or connect via Excel (as tests). 

Duane

Sent from my mobile

On Aug 1, 2023, at 7:47 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Yes, creating DSN outside Ms.Access is successfully connected with MySql database:

<image.png>

On Tue, Aug 1, 2023 at 4:59 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Creating an ODBC/DSN can be accomplished completely outside of Access. Is this successful? Will the DSN connect?

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Ahmed Hashim <ahmedhashim1@gmail.com>
Sent: Tuesday, August 1, 2023 12:52 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Error while Linking Table from MySql to Ms.Access

 

Hi to All,

I am trying to connect and link Mysql table with Ms.Access, but everytime using wizard it shows following error:

<image.png>

I've tried via ODBC (file, system and machine DSN), and received the same error every time.

Environment Information:

Windows 10 64bit

Ms. Office version 2019 64bit

MySql version: mysql  Ver 15.1 Distrib 10.4.20-MariaDB, for Win64 (AMD64), source revision c7ee039d36f69f24fb3b1c422fcff8dbf974e3eb

MySql ODBC Driver/Connector: MySQL ODBC 8.1

Any help/suggestion will be highly appreciated.

best regards

Ahmed Hashim

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116426) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Re: [MSAccessProfessionals] Error while Linking Table from MySql to Ms.Access

Did you attempt the pass-through query in Access? There might be an incompatibility issue with one or more fields. Can you try link to a very simple table?

Duane

On Aug 1, 2023, at 10:24 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Duane,

Surprisingly Excel is able to get connected with MySql and even import data via ODBC without any errors.

regards

Ahmed

On Tue, Aug 1, 2023 at 6:27 PM Duane Hookom <duanehookom@hotmail.com> wrote:

I would try create a pass-through query or connect via Excel (as tests). 

Duane

Sent from my mobile

On Aug 1, 2023, at 7:47 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Yes, creating DSN outside Ms.Access is successfully connected with MySql database:

<image.png>

On Tue, Aug 1, 2023 at 4:59 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Creating an ODBC/DSN can be accomplished completely outside of Access. Is this successful? Will the DSN connect?

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Ahmed Hashim <ahmedhashim1@gmail.com>
Sent: Tuesday, August 1, 2023 12:52 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Error while Linking Table from MySql to Ms.Access

 

Hi to All,

I am trying to connect and link Mysql table with Ms.Access, but everytime using wizard it shows following error:

<image.png>

I've tried via ODBC (file, system and machine DSN), and received the same error every time.

Environment Information:

Windows 10 64bit

Ms. Office version 2019 64bit

MySql version: mysql  Ver 15.1 Distrib 10.4.20-MariaDB, for Win64 (AMD64), source revision c7ee039d36f69f24fb3b1c422fcff8dbf974e3eb

MySql ODBC Driver/Connector: MySQL ODBC 8.1

Any help/suggestion will be highly appreciated.

best regards

Ahmed Hashim