Home
>
WinDev Forum
>
Topic
Access and manage Microsoft Access File (*.mdb) usning WinDev 12
Posted by Antonino.pcs.crosspost
|
Antonino.pcs.crosspost
Access and manage Microsoft Access File (*.mdb) usning WinDev 12 April 29, 2009 05:48PM |
|
Fabrice Harari.pcs.crosspost
Re: Access and manage Microsoft Access File (*.mdb) usning WinDev April 30, 2009 08:39AM |
Hi Antonino...
sure you can...
One easy way is to drag and drop your mdb file in the analysis to get
all files structures... You can then creates windows with tables to
display the content and the right clic menu will let you export to
excel... NO coding necessary...
Of course, you can also do the whole thing by code
Best regards
--
Fabrice Harari
Consultant WinDev, WebDev et WinDev Mobile International
Plus d'information sur [fabriceharari.com]
Antonino wrote:
> Hello everyone!
>
> I would like to know if and how I can access and manage a Microsoft Access database file (*.mdb) using WinDev 12. All I need to do is extract the content of same tables from this mdb file to excel.
>
> Any idea?
>
>
> Thanks a lot!!!
>
Message forwarded from pcsoft.us.windev
sure you can...
One easy way is to drag and drop your mdb file in the analysis to get
all files structures... You can then creates windows with tables to
display the content and the right clic menu will let you export to
excel... NO coding necessary...
Of course, you can also do the whole thing by code
Best regards
--
Fabrice Harari
Consultant WinDev, WebDev et WinDev Mobile International
Plus d'information sur [fabriceharari.com]
Antonino wrote:
> Hello everyone!
>
> I would like to know if and how I can access and manage a Microsoft Access database file (*.mdb) using WinDev 12. All I need to do is extract the content of same tables from this mdb file to excel.
>
> Any idea?
>
>
> Thanks a lot!!!
>
Message forwarded from pcsoft.us.windev
|
Antonino.pcs.crosspost
Re: Access and manage Microsoft Access File (*.mdb) usning WinDev April 30, 2009 11:15AM |
Hi Fabrice, thanks again for your support!
I do need to manage these *.mdb file by code. What I need to do is to let the user choose the file they need with the fSelect function and then manage this file. The program will have to extract all the content of some tables to excel or to its internal analysis. Is there any built-in function to do that? If not, I can I achive this goal?
Kindest Regards!
Message forwarded from pcsoft.us.windev
I do need to manage these *.mdb file by code. What I need to do is to let the user choose the file they need with the fSelect function and then manage this file. The program will have to extract all the content of some tables to excel or to its internal analysis. Is there any built-in function to do that? If not, I can I achive this goal?
Kindest Regards!
Message forwarded from pcsoft.us.windev
|
Fabrice Harari.pcs.crosspost
Re: Access and manage Microsoft Access File (*.mdb) usning WinDev April 30, 2009 01:35PM |
Hi again...
if the mdb files are always the same format, then you can still drag one
in the analysis to have the files' schema available...
If not, then you can use an ODBC connection to the MDB and then sqlCol
to read the data...
The XLSxxx functions will allow you to write what you need in the xls files
best regards
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
More information on [www.fabriceharari.com]
Antonino wrote:
> Hi Fabrice, thanks again for your support!
>
> I do need to manage these *.mdb file by code. What I need to do is to let the user choose the file they need with the fSelect function and then manage this file. The program will have to extract all the content of some tables to excel or to its internal analysis. Is there any built-in function to do that? If not, I can I achive this goal?
>
>
> Kindest Regards!
>
Message forwarded from pcsoft.us.windev
if the mdb files are always the same format, then you can still drag one
in the analysis to have the files' schema available...
If not, then you can use an ODBC connection to the MDB and then sqlCol
to read the data...
The XLSxxx functions will allow you to write what you need in the xls files
best regards
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
More information on [www.fabriceharari.com]
Antonino wrote:
> Hi Fabrice, thanks again for your support!
>
> I do need to manage these *.mdb file by code. What I need to do is to let the user choose the file they need with the fSelect function and then manage this file. The program will have to extract all the content of some tables to excel or to its internal analysis. Is there any built-in function to do that? If not, I can I achive this goal?
>
>
> Kindest Regards!
>
Message forwarded from pcsoft.us.windev
|
Antonino Neri.pcs.crosspost
Re: Access and manage Microsoft Access File (*.mdb) usning WinDev May 01, 2009 07:27PM |
|
Fabrice Harari.pcs.crosspost
Re: Access and manage Microsoft Access File (*.mdb) usning WinDev May 02, 2009 03:53PM |
Hi Antonino...
the help file, keyword ODBC gives you all the information you'll need...
If you have a problem after that, just ask a precise question here
Best regards
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
More information on [www.fabriceharari.com]
Antonino Neri wrote:
> Hi Fabrice...
>
> I have never used an ODBC connection before. How can I create and manage this type of connection? Is there any useful document about that?
>
>
> Thanks for you time!!!
>
> Regards
>
Message forwarded from pcsoft.us.windev
the help file, keyword ODBC gives you all the information you'll need...
If you have a problem after that, just ask a precise question here
Best regards
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
More information on [www.fabriceharari.com]
Antonino Neri wrote:
> Hi Fabrice...
>
> I have never used an ODBC connection before. How can I create and manage this type of connection? Is there any useful document about that?
>
>
> Thanks for you time!!!
>
> Regards
>
Message forwarded from pcsoft.us.windev