Read an Excel file via adodc

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Juvenel Joseph (rorojoseph_at_hotmail.com)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 03:12:38 -0700

I want to import and read an Excel file into my vb application. I use
often adodc or an adodb.recordser objet to access database.

Please show me the way to do it.

Thank for all.

Juvenel

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: I need an access programmer $
    ... John Vinson's answer in the newsgroup should be all that you need. ... quality *free* support to Access enthusiasts and users. ... > putting it back into the Access database where it belongs is new for me. ... I need the macro to read the Excel file, ...
    (microsoft.public.access.gettingstarted)
  • Re: make a file private
    ... You can add a password to an Access database, you can add a password to a Word document or an Excel file. ... It depends from whom you are trying to conceal the info - if it's just a casual nose-parker then a strong password may suffice - if not then you will have to consider a commercial encryption application. ...
    (microsoft.public.office.misc)
  • Re: How to retrieve original huge data from pivottable?
    ... Instead of double-clicking on the grand total cell, double-click on one of the subtotals, if it will have fewer than 65536 records. ... access database(more than 800000 records), and now, I have only excel file and without access file, but I must get the original records for my work? ... I try use the VBA pivotcache object,but I failed, for pivotcache object has no methods to export data. ...
    (microsoft.public.excel.misc)
  • Re: ado, excel
    ... Try importing the Excel file into your current open FP web / site, ... you will do better using an Access database. ... The Microsoft Jet database engine cannot open the file ''. ... FrontPage Support: http://www.frontpagemvps.com/ ...
    (microsoft.public.frontpage.programming)
  • New record in table in Access from VBA in Excel
    ... I have an excel file that that a customer uses to order product. ... order2.xls,..order40.xls) I have an Access database that I use to track jobs ... Place information from the excel file into certain fields in the table. ... Compile error: ...
    (microsoft.public.excel.programming)