How to send data from Excel to a Database

Posted to microsoft.public.excel.programming

Bob[_32_]

external usenet poster

Posts: 1

How to send data from Excel to a Database

I'm familiar with pulling data into Excel from an external
datasource, but can it push data into an external source
(e.g. Access or any other ODBC database) and how? I've
been struggling with the QueryTables method and building
an INSERT query to no avail.

Thanks in advance.

Bob

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
database query not showing foxpro database How I import data	mangat	New Users to Excel	1	June 24th 07 03:31 PM
How do I send data to a person or BCC a group in excel?	jonathan k	Excel Discussion (Misc queries)	3	May 28th 06 09:34 AM
My send to in excel/word does not offer send as attachment	Mstink	Excel Discussion (Misc queries)	11	March 16th 06 02:49 PM
how i make the excel send data or save it to another bad file	[email protected]	Excel Worksheet Functions	1	August 31st 05 02:02 PM
Send Excel data to Access through button	julesferreira	Excel Discussion (Misc queries)	1	June 17th 05 07:30 PM

All times are GMT +1. The time now is 06:31 AM.

Menu

About Us