borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder

AndreaVB | Forum | News | Downloads | Register | Help | Member List | Statistics | Search | PM | Profile

Print This Topic
Previous Topic (Calculate correct week numbers)Next Topic (tulong mga kbyan!!!!!) New Topic New Poll Post Reply
AndreaVB Forum : VBA (Access, Excel, Word, ...) : transffering my database to excell??
Poster Message
elric(1)
Level: Protégé


Registered: 10-01-2007
Posts: 5

icon transffering my database to excell??

how could i transffer my database in excell? like report or so... please help...     

10-01-2007 at 03:40 AM
View Profile Send Email to User Show All Posts | Quote Reply
gosamerone
Level: Big Cheese

Registered: 22-03-2005
Posts: 20
icon Re: transffering my database to excell??

Use the OutputTo method in either VBA or create a macro using it.

OutputTo(ObjectType, ObjectName, OutputFormat, OutputFile, AutoStart, TemplateFile, Encoding)

25-01-2007 at 07:51 PM
View Profile Send Email to User Show All Posts | Quote Reply
elric
Level: Scholar


Registered: 09-07-2006
Posts: 35
icon Re: transffering my database to excell??

umm but could you give me a sample code on how to use it?

____________________________
-same thing over and over again..-

13-02-2007 at 12:58 AM
View Profile Send Email to User Show All Posts | Quote Reply
gosamerone
Level: Big Cheese

Registered: 22-03-2005
Posts: 20
icon Re: transffering my database to excell??

DoCmd.OutputTo acOutputTable, "Table1", acFormatXLS, "Table1.xls", yes

Assuming you are using VBA

13-02-2007 at 08:38 PM
View Profile Send Email to User Show All Posts | Quote Reply
lily_and
Level: Trainee

Registered: 14-03-2007
Posts: 2
icon Re: transffering my database to excell??

ABC Amber Word2Excel Converter gives you a new way to convert tables from Word to Excel quickly and easily.
http://www.qweas.com/download/converters/document_converters/abc_amber_word2excel_converter.htm
ABC Amber Word2Excel Converter is an advanced utility which helps you convert tables from DOC (MS Word) files to XLS (MS Excel) easily and quickly.

ABC Amber Word2Excel Converter can read DOC (MS Word) files, and export tables from the DOC files to XLS file. It can support batch conversion, this make you convert conveniently. This program supports multi-language and command line and more. You will work easily with it.



____________________________
http://www.qweas.com/

14-03-2007 at 07:59 AM
View Profile Send Email to User Show All Posts | Quote Reply
AndreaVB Forum : VBA (Access, Excel, Word, ...) : transffering my database to excell??
Previous Topic (Calculate correct week numbers)Next Topic (tulong mga kbyan!!!!!) New Topic New Poll Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
Partners: Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder