Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
6
Erster Beitrag:
vor 8 Jahren, 7 Monaten
Letzter Beitrag:
vor 8 Jahren, 7 Monaten
Beteiligte Autoren:
Fabrice Harari.pcs.crosspost, Antonino.pcs.crosspost, Antonino Neri.pcs.crosspost

Access and manage Microsoft Access File (*.mdb) usning WinDev 12

Startbeitrag von Antonino.pcs.crosspost am 29.04.2009 15:48

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

Antworten:

Re: Access and manage Microsoft Access File (*.mdb) usning WinDev

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 http://fabriceharari.com/index_FR.html




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

von Fabrice Harari.pcs.crosspost - am 30.04.2009 06:39

Re: Access and manage Microsoft Access File (*.mdb) usning WinDev

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

von Antonino.pcs.crosspost - am 30.04.2009 09:15

Re: Access and manage Microsoft Access File (*.mdb) usning WinDev

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 http://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

von Fabrice Harari.pcs.crosspost - am 30.04.2009 11:35

Re: Access and manage Microsoft Access File (*.mdb) usning WinDev

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

von Antonino Neri.pcs.crosspost - am 01.05.2009 17:27

Re: Access and manage Microsoft Access File (*.mdb) usning WinDev

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 http://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

von Fabrice Harari.pcs.crosspost - am 02.05.2009 13:53
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.