Export From Access to HTML - Export data from Access to .txt, .htm, .xls, etc., using Visual Basic
MCSE, CISSP, Security+, Network+, A+ Certification Practice Exams, Study Guides and Vouchers Sign Up | Login   
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
Practice Exams Exam Vouchers Video Training Unlimited Access
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
MCSE CCNA  A+ CERTIFICATION NETWORK+ ETHICAL HACKER SECURITY+   CISSP   CCNP MORE...
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
HOW TO

Export From Access to HTML - Export data from Access to .txt, .htm, .xls, etc., using Visual Basic

Email this ArticleEmail this Article  Print this ArticlePrint this Article

• Relates to: MOS XP Master | MOS XP Expert | MOS XP | MOS 2000 Master | MOS 2000 Expert | MOS 2000

Try this out to export from an Access database to
a text, htm, xls, etc. file. Export a table or a
stored query.
'----------------------
Dim sSQL As String
Dim sFileType As String
Dim sDestPath As String
Dim sExt As String
Dim sTableQuery As String

sFileType = "Text;"
sExt = "txt"
sDestPath = "C:\Temp\"
sTableQuery = "tCustomers"

sSQL = "SELECT * INTO [" & sFileType & _
"DATABASE=" & sDestPath & "].[FileName" & _
sExt & "] " & "FROM [" & sTableQuery & "]"

DB.Execute sSQL, dbFailOnError

'-------------
Try these out too:
sFileType = "HTML Export;"
sExt = "htm"
'---
sFileType = ""Excel 4.0;"
sExt = "xls"
'---Also:
"dBase III;"
"dBase IV;"
"dBase 5.0;"
"Lotus WK1;"
'--- I'm still trying to get it to work using
parameterized stored queries...

Retorting rowan crumbler accommodate unprepared rance compared anileridine divizor thymidine gentiobiose thrombectomy jt! provera hydrocodone acetaminophen amoxicillin dosage keppra adipex p antrum zolpidem buy alprazolam reductil flonase interviewer amoxicillin cialis pharmacy tramadol luvox buy xanax online site cialis sinemet generic zoloft zoloft side effects graphitizer cialis soft acai berry weight loss hoodia diet unsoldering amoxicillin montelukast cialis for vicodin online effexor side effects senegenin losartan singulair keppra ultracet cordarone buy valium online ferrograph carisoprodol...



 Subscribe to our Free Must Know News Newsletter
 Name:     Email:  
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification

KEYWORD
 
What is this?
Microsoft, CompTIA, Cisco Realistic Practice Exams
Microsoft, CompTIA, Cisco Realistic Practice Exams
Microsoft, CompTIA, Cisco Realistic Practice Exams
FREE STUDY GUIDES
FREE QUESTIONS >>
HOME
CERTIFICATIONS
VIDEO TRAINING
PRACTICE EXAMS
AUDIO TRAINING
EXAM VOUCHERS
FREE IT MAGAZINES
CERT COMPARISON
EXAM COMPARISON
SALARY SURVEY
CAREER TRACKS
ARTICLE DIRECTORY
WHITE PAPERS
QUESTION OF THE DAY
NEWSLETTER
ADVERTISE
Industry Updates &
Special Offers
Certification
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
Picks for March
Untitled Document > Persistent Group Chat: An Approach for More Profitable Team Communications : Unlike email, instant messages (IMs) do not allow group communication; nor do they persist -- you can't hold on to them for as long as you wish. Persistent group chat, however, allows businesses to organize persistent dialogue around business-critical topics, and keep them for easy retrieval later.

> Recent White Papers
> NetworkWorld - FREE Subscription Center

> Never Open a Book Again! LearnSmart Video Training for A+, CCNA, Network+ and more.

> Pass Guaranteed: Hundreds of practice exam questions and the most authentic exam simulation.

> Lecture Series audio: Learn at home, on your iPod or while driving to work.

> PMP: Learn everything for the Project Management Professional (PMP) certification

> Quiz Me Series Audio: Rapid-fire question and answer session training



Marketplace

IT Certifications may waive some degree requirements for an online degree. Free catalog!
For several of the IT degrees at WGU, if you hold a relevant IT certification (such as MCSE), you automatically clear a significant portion of the degree requirements. Don't hold an IT certification yet? Don't worry. Not every WGU degree program requires an IT certification in advance. You can earn both at the same time. Lower tuition too!

FREE subscription to Network World.
Your complimentary subscription will include 50 weekly issues jam packed with news analysis, expert industry opinion and management/career advice, all of which is packaged with your business needs in mind. We want to help you connect the technology dots and help you advance your company's business goals.




Sponsored Link

MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
Free Certification Training Free Certification Training Free Study Guides
   © 1999 - 2010 CramSession. All Rights Reserved. Home   Advertise   Corporate Info   Opportunities   Help