Jet Arf

Error 80040e37: Inserting to Excel from Access ADO and VBA?

I'm getting a runtime error when I try to insert the contents of MyTable to an Excel spreadsheet.

"The Microsoft Jet database engine could not find the object 'MyTable'. Make sure the object exists, and you spell it's name and the path name correctly."

The full string at runtime reads:
SELECT MyTable.* INTO [Excel 8.0;Database=
C:Documents and SettingssollyMy Documentsarf.xls].
[Sheet2] FROM MyTable

If I try to write a hard-coded string to the spreadsheet, it works. It fails when it tries to fetch the data from the source, which is a table in the .mdb that hosts the code I'm writing. The name IS spelled correctly.
Turns out this is a bug in Office 2003 SP2 and greater. *sigh*

i havent tried this before, and the fact that tou got this to work is confusing...this will make my answer incorrect.
but here goes anyway.

isnt the SELECT statement supposed to retrieve your columns?
maybe you can try SELECT (one column name)...its possible you have a column called MyTable within your MyTable database.

or even SELECT *

the * should select all columns.

im all out of ideas.

SUPER HUGE12M RC F35 Lighting II ARF Jet Plane Vehicle Aerobatic 70MM EDF GIFT
SUPER HUGE12M RC F35 Lighting II ARF Jet Plane Vehicle Aerobatic 70MM EDF GIFT
$449.99
Time Remaining: 1d 13m
Buy It Now for only: $449.99

A10 GRAY Remote Control Dual EDF Jet Airplane ARF
A10 GRAY Remote Control Dual EDF Jet Airplane ARF
$20.49 (2 Bids)
Time Remaining: 1d 19h 42m

Very Cool 12M RC F16 Falcon model PNP ARF Airplane Jet Motor EDF Vector Nozzle
Very Cool 12M RC F16 Falcon model PNP ARF Airplane Jet Motor EDF Vector Nozzle
$229.99
Time Remaining: 2d 33m
Buy It Now for only: $229.99

DIY Foam Park Jet RC Plane ARF w servos 3Ch EasyToFly
DIY Foam Park Jet RC Plane ARF w servos 3Ch EasyToFly
$49.95
Time Remaining: 2d 3h 56m
Buy It Now for only: $49.95

F 16 F 16 360 Degree Thrust Vector RC Electric Jet EPO ARF
F 16 F 16 360 Degree Thrust Vector RC Electric Jet EPO ARF
$224.95
Time Remaining: 3d 10h 20m
Buy It Now for only: $224.95

ElectriFly Evader EDF EP Sport Jet ARF GPMA1800
ElectriFly Evader EDF EP Sport Jet ARF GPMA1800
$173.41
Time Remaining: 5d 35m
Buy It Now for only: $173.41

ElectriFly F 20 Tigershark Jet EDF ARF GPMA1875
ElectriFly F 20 Tigershark Jet EDF ARF GPMA1875
$108.02
Time Remaining: 5d 59m
Buy It Now for only: $108.02

Great Planes ElectriFly F 20 Tigershark Jet ARF GPMA1875
Great Planes ElectriFly F 20 Tigershark Jet ARF GPMA1875
$97.51
Time Remaining: 8d 12h 38m
Buy It Now for only: $97.51

Great Planes Evader EDF Sport Jet ARF 265 GPMA1800 NIB
Great Planes Evader EDF Sport Jet ARF 265 GPMA1800 NIB
$159.99
Time Remaining: 9d 15h 14m
Buy It Now for only: $159.99

Bruce Lee 90mm Ducted Fan Jet Plane Fibreglass ARF Kit NEW IN BOX
Bruce Lee 90mm Ducted Fan Jet Plane Fibreglass ARF Kit NEW IN BOX
$459.00
Time Remaining: 11d 5h 26m
Buy It Now for only: $459.00

Great Planes Phazer EDF EP Sport Jet ARF GPMA1802
Great Planes Phazer EDF EP Sport Jet ARF GPMA1802
$179.97
Time Remaining: 11d 15h 48m
Buy It Now for only: $179.97

RC Mig 15 Fiberglass 90mm EDF Jet 1127mm ARF
RC Mig 15 Fiberglass 90mm EDF Jet 1127mm ARF
$200.54
Time Remaining: 12d 5h 15m
Buy It Now for only: $200.54

NEW Great Planes Phazer EDF Sport Jet EP ARF 23 GPMA1802 NIB
NEW Great Planes Phazer EDF Sport Jet EP ARF 23 GPMA1802 NIB
$179.97
Time Remaining: 12d 14h 48m
Buy It Now for only: $179.97

Great Planes F 20 Tigershark Jet w Motor ARF 225 R C Airplane Kit GPMA1875 GP
Great Planes F 20 Tigershark Jet w Motor ARF 225 R C Airplane Kit GPMA1875 GP
$129.98
Time Remaining: 12d 18h 50m
Buy It Now for only: $129.98

World Models Wing Jet EP ARF WME210
World Models Wing Jet EP ARF WME210
$124.99
Time Remaining: 12d 22h 51m
Buy It Now for only: $124.99

VENOM 6803 THE HUFF F86 70 ARF SABRE JET EDF NEW KIT in Canada
VENOM 6803 THE HUFF F86 70 ARF SABRE JET EDF NEW KIT in Canada
$182.50
Time Remaining: 13d 21h 3m
Buy It Now for only: $182.50

F 16 EDF JET 3 CH MIni v2 w gyro ARF
F 16 EDF JET 3 CH MIni v2 w gyro ARF
$125.00
Time Remaining: 14d 16h 44m
Buy It Now for only: $125.00

New 3Ch RC R c EP 252 Baby Cat Aerobatic Foamy ARF EDF Jet Plane Airplane
New 3Ch RC R c EP 252 Baby Cat Aerobatic Foamy ARF EDF Jet Plane Airplane
$55.20
Time Remaining: 15d 5h 12m
Buy It Now for only: $55.20

SUPER HUGE15M RC MIG29 ARF PNP Jet Plane Aerobatic Twin 70MM EDF Motor IMax B6
SUPER HUGE15M RC MIG29 ARF PNP Jet Plane Aerobatic Twin 70MM EDF Motor IMax B6
$659.00
Time Remaining: 15d 13h 30m
Buy It Now for only: $659.00

Viper Jet 70 Fiberglass 1050mm WingSpan 70mm EDF ARF Plane Only
Viper Jet 70 Fiberglass 1050mm WingSpan 70mm EDF ARF Plane Only
$139.98
Time Remaining: 16d 10h 2m
Buy It Now for only: $139.98

Air Earl Passenger 2 Channel R C ARF30 Wingspan Jet PlanePowerHobby
Air Earl Passenger 2 Channel R C ARF30 Wingspan Jet PlanePowerHobby
$79.95
Time Remaining: 16d 16h 23m
Buy It Now for only: $79.95

Scratch built 1950s ara Venom British fighter jet uses a P 120 jet engine ARF
Scratch built 1950s ara Venom British fighter jet uses a P 120 jet engine ARF
$1,700.00
Time Remaining: 16d 19h 29m
Buy It Now for only: $1,700.00

Navy Cat Turbine Jet Carbon Fiber Version ARF XY 292
Navy Cat Turbine Jet Carbon Fiber Version ARF XY 292
$399.00
Time Remaining: 19d 1h 56m
Buy It Now for only: $399.00

R C Passenger Jet A320 AIR BUS 1540mm  ARF TS 831 PlanePowerHobby
R C Passenger Jet A320 AIR BUS 1540mm ARF TS 831 PlanePowerHobby
$399.99
Time Remaining: 19d 8h 47m
Buy It Now for only: $399.99

SUPER HUGE15M RC Green MIG29 ARF PNP Jet Plane Aerobatic Twin 70MM EDF iMax B6
SUPER HUGE15M RC Green MIG29 ARF PNP Jet Plane Aerobatic Twin 70MM EDF iMax B6
$669.00
Time Remaining: 19d 16h
Buy It Now for only: $669.00

SUPER HUGE 13M RC YF 23 ARF Jet Plane Aerobatic 70mm Twin EDF Metal Retract
SUPER HUGE 13M RC YF 23 ARF Jet Plane Aerobatic 70mm Twin EDF Metal Retract
$699.00
Time Remaining: 20d 14h 58m
Buy It Now for only: $699.00

Very Cool 950MM Length RC 4CH F22 Raptor model PNP ARF Airplane Jet Motor EDF
Very Cool 950MM Length RC 4CH F22 Raptor model PNP ARF Airplane Jet Motor EDF
$229.99
Time Remaining: 21d 1h 54m
Buy It Now for only: $229.99

New RC Radio Electric Stealth Fighter plane F117 100cm Large Jet ARF PNF
New RC Radio Electric Stealth Fighter plane F117 100cm Large Jet ARF PNF
$299.99
Time Remaining: 22d 4h 56m
Buy It Now for only: $299.99

New RC Radio Electric EDF Jet Plane F 22 Remote Controlled RAPTOR ARF
New RC Radio Electric EDF Jet Plane F 22 Remote Controlled RAPTOR ARF
$349.99
Time Remaining: 22d 5h 6m
Buy It Now for only: $349.99

RC Electric EDF Jet Plane Lockheed SR 71 Blackbird ARF PnF Twin Motor
RC Electric EDF Jet Plane Lockheed SR 71 Blackbird ARF PnF Twin Motor
$359.99
Time Remaining: 22d 5h 15m
Buy It Now for only: $359.99

RC Electric EDF Jet Plane F117 Blackbird Radio Controlled ARF PnF
RC Electric EDF Jet Plane F117 Blackbird Radio Controlled ARF PnF
$369.99
Time Remaining: 22d 5h 50m
Buy It Now for only: $369.99

RC Electric EDF Jet B 2 Spirit Stealth Bomber Radio Controlled ARF PnF
RC Electric EDF Jet B 2 Spirit Stealth Bomber Radio Controlled ARF PnF
$449.99
Time Remaining: 22d 6h 1m
Buy It Now for only: $449.99

RC Electric EDF Jet Plane F 35 Lightning Radio Controlled ARF PnF
RC Electric EDF Jet Plane F 35 Lightning Radio Controlled ARF PnF
$459.99
Time Remaining: 22d 6h 4m
Buy It Now for only: $459.99

RC Electric EDF Jet Plane SU47 Russoan Sukhoi Radio Controlled ARF PnF
RC Electric EDF Jet Plane SU47 Russoan Sukhoi Radio Controlled ARF PnF
$499.99
Time Remaining: 22d 6h 7m
Buy It Now for only: $499.99

RC Electric EDF Jet Plane MIG 29 Radio Controlled ARF PnF
RC Electric EDF Jet Plane MIG 29 Radio Controlled ARF PnF
$599.99
Time Remaining: 22d 6h 10m
Buy It Now for only: $599.99

RC Electric EDF Jet Plane A10 Warthog Radio Controlled ARF PnF
RC Electric EDF Jet Plane A10 Warthog Radio Controlled ARF PnF
$549.99
Time Remaining: 22d 6h 14m
Buy It Now for only: $549.99

RC Electric EDF Jet Plane F 18 1 Hornet Strike Fighter Radio Controlled ARF PnF
RC Electric EDF Jet Plane F 18 1 Hornet Strike Fighter Radio Controlled ARF PnF
$699.99
Time Remaining: 22d 6h 18m
Buy It Now for only: $699.99

RC Electric EDF Jet Plane F 18 2 Hornet Strike Fighter Radio Controlled ARF PnF
RC Electric EDF Jet Plane F 18 2 Hornet Strike Fighter Radio Controlled ARF PnF
$699.99
Time Remaining: 22d 6h 23m
Buy It Now for only: $699.99

RC Electric EDF Jet Plane F 18 3 Hornet Strike Fighter Radio Controlled ARF PnF
RC Electric EDF Jet Plane F 18 3 Hornet Strike Fighter Radio Controlled ARF PnF
$699.99
Time Remaining: 22d 6h 24m
Buy It Now for only: $699.99

SUPER HUGE RC B2 Spirit Stealth Bomber ARF PNP Model Jet Plane Twin 64MM EDF
SUPER HUGE RC B2 Spirit Stealth Bomber ARF PNP Model Jet Plane Twin 64MM EDF
$419.99
Time Remaining: 22d 12h 26m
Buy It Now for only: $419.99

SUPER HUGE 14M RC A10 Warthog ARF Model Jet Plane Aerobatic Twin EDF Motor
SUPER HUGE 14M RC A10 Warthog ARF Model Jet Plane Aerobatic Twin EDF Motor
$649.00
Time Remaining: 23d 10h 17m
Buy It Now for only: $649.00

Great Planes ElectriFly F 20 Tigershark Jet EDF ARF GPMA1875
Great Planes ElectriFly F 20 Tigershark Jet EDF ARF GPMA1875
$100.72
Time Remaining: 23d 20h 17m
Buy It Now for only: $100.72

A 7 US Navy Jet RC Airplane 70mm EDF and Servos Included ARF
A 7 US Navy Jet RC Airplane 70mm EDF and Servos Included ARF
$134.95
Time Remaining: 24d 15h 27m
Buy It Now for only: $134.95

SUPER HUGE 1175M RC F117 Nighthawk ARF Model Jet Plane Aerobatic 70MM EDF
SUPER HUGE 1175M RC F117 Nighthawk ARF Model Jet Plane Aerobatic 70MM EDF
$345.00
Time Remaining: 25d 1h 42m
Buy It Now for only: $345.00

SUPER HUGE13M RC ARF F16 Fighting Falcon Jet Plane Vehicle Vector Nozzle
SUPER HUGE13M RC ARF F16 Fighting Falcon Jet Plane Vehicle Vector Nozzle
$449.00
Time Remaining: 26d 19h 56m
Buy It Now for only: $449.00

161M SUPER HUGE RC SU35 ARF PNP Model Aircraft Jet Plane Twin EDF Motor
161M SUPER HUGE RC SU35 ARF PNP Model Aircraft Jet Plane Twin EDF Motor
$479.99
Time Remaining: 27d 16m
Buy It Now for only: $479.99

SUPER HUGE 125M RC F22 Raptor Included ARF Model Jet Plane 70mm EDF Motor
SUPER HUGE 125M RC F22 Raptor Included ARF Model Jet Plane 70mm EDF Motor
$299.99
Time Remaining: 27d 11h 41m
Buy It Now for only: $299.99

Combo Retracts + Navy Cat Turbine Jet Carbon Fiber Version ARF XY 292
Combo Retracts + Navy Cat Turbine Jet Carbon Fiber Version ARF XY 292
$599.00
Time Remaining: 28d 16h 32m
Buy It Now for only: $599.00

SUPER HUGEHandsome16M RC SU35 ARF PNP Model Aircraft Jet Plane Twin EDF Motor
SUPER HUGEHandsome16M RC SU35 ARF PNP Model Aircraft Jet Plane Twin EDF Motor
$518.00
Time Remaining: 28d 21h 27m
Buy It Now for only: $518.00

Great Planes ElectriFly Evader EDF EP Sport Jet ARF GPMA1800
Great Planes ElectriFly Evader EDF EP Sport Jet ARF GPMA1800
$176.98
Time Remaining: 29d 1h 12m
Buy It Now for only: $176.98

Great Planes ElectriFly F 20 Tigershark Jet ARF GPMA1875
Great Planes ElectriFly F 20 Tigershark Jet ARF GPMA1875
$98.99
Time Remaining: 29d 1h 31m
Buy It Now for only: $98.99

Great Planes ElectriFly Evader EDF EP Sport Jet ARF GPMA1800
Great Planes ElectriFly Evader EDF EP Sport Jet ARF GPMA1800
$167.31
Time Remaining: 29d 21h 51m
Buy It Now for only: $167.31


Comments are closed.