Home Register Calendar Today's Posts FAQ
\r\n\r\n
Interoperation / Office Integration Topics include: COM, P/Invoke (e.g. Win32 API), marshaling, distributed applications, VBA and interacting with office apps

Go Back  Xtreme .NET Talk > .NET > Interoperation / Office Integration > Opening Excel and downloading into Access using .NET


\r\n \r\n \r\n \r\n
 
 
Thread Tools Display Modes
\r\n \r\n
\r\n
\r\n \r\n I am developing a program that I want to open an excel file take that information and insert it into the proper fields in an Access 2000 database. My main problem is figuring out how to open a Existing excel file using Visual Basic.NET. Any help with the correct programming syntax on how to accomplish this task would be greatly appreciated.\r\n
\r\n
\r\n \r\n
\r\n \r\n\r\n \r\n \r\n\r\n \r\n\r\n \r\n\r\n \r\n\r\n
\r\n \r\n \r\n \r\n \r\n Reply With Quote\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n\r\n \r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n \r\n \r\n \r\n\r\n\r\n\r\n\r\n'; pd[189840] = '\r\n\r\n \r\n\r\n
\r\n
\r\n
\r\n\r\n
\r\n \r\n\r\n\r\n\r\n\r\n\r\n \r\n\r\n\r\n\r\n \r\n \r\n\r\n
\r\n
\r\n  \r\n #2  \r\n \r\n \r\n \r\n \r\n \r\n
\r\n\r\n
\r\n \r\n Old\r\n \r\n 08-28-2002, 03:34 PM\r\n \r\n \r\n \r\n
\r\n
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Derek Stone\'s Avatar\r\n\r\n
\r\n \r\n Derek Stone\r\n Derek Stone is offline\r\n\r\n\r\n
\r\n \r\n
\r\n
\r\n \r\n I was unfamiliar with the Visual Basic counter part of how to accomplish this. A quick sample of how to do this would be greatly appreciated.\r\n
\r\n
\r\n \r\n
\r\n \r\n\r\n \r\n \r\n\r\n \r\n\r\n \r\n\r\n \r\n\r\n
\r\n \r\n \r\n \r\n \r\n Reply With Quote\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n\r\n \r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n \r\n
\r\n
\r\n
\r\n\r\n\r\n\r\n'; // next/previous post info pn[189713] = "190036,189840"; pn[0] = ",189713"; pn[189840] = "189713,190036"; pn[190036] = "189840,189713"; // cached usernames pu[0] = guestphrase; pu[11949] = "lothos12345"; pu[1833] = "Derek Stone"; // -->
Prev Previous Post   Next Post Next
  #1  
Old 08-28-2002, 01:15 PM
lothos12345 lothos12345 is offline
Junior Contributor
  
Join Date: May 2002
Location: Texas
Posts: 294
lothos12345 is on a distinguished road
Smile Opening Excel and downloading into Access using .NET
I am developing a program that I want to open an excel file take that information and insert it into the proper fields in an Access 2000 database. My main problem is figuring out how to open a Existing excel file using Visual Basic.NET. Any help with the correct programming syntax on how to accomplish this task would be greatly appreciated.
Reply With Quote
 

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Threaded Mode Threaded Mode

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
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Issue with opening a file that I am downloading. mike55 ASP.NET 3 11-10-2006 03:40 AM
Newbie Q: Opening Excel Workbook from c#??? ThienZ Interoperation / Office Integration 1 03-16-2005 07:21 AM
Error while opening excel v9.0 (2000) workbook in .NET dimple Interoperation / Office Integration 3 03-24-2004 09:17 AM
Access -> Excel using VB.net absent Database / XML / Reporting 2 02-05-2004 08:30 AM
VB.net try to access Marco password protected excel file jackps General 0 01-08-2004 01:16 AM

Advertisement:


Home
Register
Calendar
Today's Posts
FAQ
Archive
Powered by liquidweb © XtremeDotNetTalk.com 2001 - 2010. All Rights Reserved.    Advertise on XtremeDotNetTalk

Other iNET Interactive Sites: Web Hosting Talk | DB Forums | Mac-Forums | Hosting Catalog | Hot Scripts

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.