Can't seem to get it... 
Author Message
 Can't seem to get it...

Trying to copy an entire table from an Access DB to an Excel file.

The code below is successful in copying the original table to the new table
within the same DB.

However, I would like to take the data from the original table in the
DB and put it into a new spreadsheet at another location on the LAN.

How can I do this?

Moreover, I want this to be a scheduled run that overwrites the same
Spreadsheet file - how can I make SURE it overwrites the same file?

Option Explicit

Dim cnPowell

Set cnPowell = CreateObject("ADODB.Connection")

cnPowell.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
  "User ID=scrump; Data Source=C:\PB2000.mdb;" & _
  "Jet OLEDB:System database=C:\secured.mdw"

cnPowell.Execute "select * into tblNew from tblOriginal"


Thanks for the help as always.


Tue, 06 Dec 2005 20:38:09 GMT  
 [ 1 post ] 

 Relevant Pages 

1. define a measurement doesn't seem to work

2. Can't seem to create an object.

3. location.replace doesn't seem to work

4. Can't seem to make server-side VBScript work

5. comparisons between decimal and hex values doesn't seem to work

6. response.expires doesn't seem to work!

7. My Script...Doesn't Seem to Work

8. Can't Seem to Get the Format Correct

9. CDONTS.DLL doesn't seem to work.

10. GS 3.51 on PC doesn't seem to find fonts

11. ASP pages can't be refreshed instantly, they seem to be loading indefinitely

12. can't seem to do this


Powered by phpBB® Forum Software