Re: using Database in EXCEL ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Marek (Marek.1c47va_at_excelforum-nospam.com)
Date: 09/05/04

Next message: Tom Ogilvy: "Re: Use ADO in VB to read excel file problem"
Previous message: Roy Miller: "Forms and Exception occured errors"
In reply to: Tom Ogilvy: "Re: using Database in EXCEL ?"
Next in thread: Robin Hammond: "Re: using Database in EXCEL ?"
Reply: Robin Hammond: "Re: using Database in EXCEL ?"
Messages sorted by: [ date ] [ thread ]

Date: Sun, 5 Sep 2004 09:56:00 -0500

thanks, all this examples is good

but maybe you know any links like

using ado with access db in excel step by step
or ado in excel step by step

i cant find any normal full tutorials, only examples,

at this point i want to ask, what is better to choose, microsoft query
or to use ADO ?

---
Message posted from http://www.ExcelForum.com/

Next message: Tom Ogilvy: "Re: Use ADO in VB to read excel file problem"
Previous message: Roy Miller: "Forms and Exception occured errors"
In reply to: Tom Ogilvy: "Re: using Database in EXCEL ?"
Next in thread: Robin Hammond: "Re: using Database in EXCEL ?"
Reply: Robin Hammond: "Re: using Database in EXCEL ?"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

RE: write data to a closed file on network drive
... I don't know much about the technical specs of ADO, ... works just for Excel too, ... Sub RS2WS ... Microsoft Active X Data Objects Recordset 2.8 Library ...
(microsoft.public.excel.programming)
Excel file bloat using ADO
... I have modified a routine based on the following WebPage that uses ADO ... to add data to closed Excel files. ... How do I update an Excel spreadsheet using ADO? ... Apparently, this is a problem with Access files, given the number of ...
(microsoft.public.excel.programming)
Re: Excel file bloat using ADO
... Rather than use a recordset, instead use INSERT INTO and UPDATE sql ... > I have modified a routine based on the following WebPage that uses ADO ... > How do I update an Excel spreadsheet using ADO? ... > Apparently, this is a problem with Access files, given the number of ...
(microsoft.public.excel.programming)
Re: SQL incorporation with Excel
... Excel 2002 VBA by Bullen, Green, Bovey and Rosenberg has a fairly good ... Set a reference to ADO 2.7 in your vb project. ... connection string to find the correct way to connect. ... Our accounting system uses an SQL ...
(microsoft.public.excel.programming)
Re: ADO programming
... It sounded to me ADO was to stay and DAO into obscurity. ... I have seen an Excel app using ADO to query against oracle, ... queries in the Excel app, it went from 15min wait to about near ...
(microsoft.public.access.modulesdaovba)