PC Review


Reply
Thread Tools Rate Thread

ADOX in VB.NET to create Excel file

 
 
Paul
Guest
Posts: n/a
 
      17th Feb 2008
Hello,

I have a VB 6 app that creates Excel files to export data that works
fine. When I ported it to VB.NET it creates the file, but seems to
finish writing the data and releasing the file only after a random
length period of time. If I use the code in the discussion "ADOX in
Office XP??" I get the same result. My code is very similar to that.
Some programming languages have a method to flush the output buffer
and close the file, but I don't see a way to do that in VB.

If I continue running the .NET app it does release the file
eventually, which makes me wonder if it has something to do with
garbage collection, but that is just a guess.


Any ideas?

Thanks
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use ADOX on Excel? How to automate Excel invocation on existing xls file from vbs? Siegfried Heintze Microsoft Excel Programming 0 7th Jun 2008 08:03 PM
VB.NET create JET database without ADOX Dan Hinsley Microsoft ADO .NET 6 25th Apr 2006 01:07 PM
Create DB without ADOX =?Utf-8?B?VGluaw==?= Microsoft Dot NET 3 20th Aug 2004 02:50 PM
create ADOX table Shaun Microsoft Access Database Table Design 1 14th Mar 2004 10:59 AM
Create DB with ADOX to use MDW file Webtree Microsoft Access Security 3 11th Jul 2003 07:47 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:08 AM.