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.

ElectriFly Evader EDF EP Sport Jet ARF GPMA1800
ElectriFly Evader EDF EP Sport Jet ARF GPMA1800
$173.41
Time Remaining: 11h 3m
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: 11h 27m
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: 3d 23h 5m
Buy It Now for only: $97.51

turbine fueler arf jet
turbine fueler arf jet
$50.00
Time Remaining: 4d 23h 54m

Great Planes Evader EDF Sport Jet ARF 265 GPMA1800 NIB
Great Planes Evader EDF Sport Jet ARF 265 GPMA1800 NIB
$159.99
Time Remaining: 5d 1h 42m
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: 6d 15h 54m
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: 7d 2h 16m
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: 7d 15h 43m
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: 8d 1h 16m
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: 8d 5h 18m
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: 8d 9h 19m
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
$181.71
Time Remaining: 9d 7h 31m
Buy It Now for only: $181.71

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: 10d 3h 12m
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: 10d 15h 40m
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: 10d 23h 58m
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: 11d 20h 30m
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
$99.00
Time Remaining: 12d 2h 51m
Buy It Now for only: $99.00

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: 12d 5h 57m
Buy It Now for only: $1,700.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: 14d 19h 15m
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: 15d 2h 28m
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: 16d 1h 26m
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: 16d 12h 22m
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: 17d 15h 24m
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: 17d 15h 34m
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: 17d 15h 43m
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: 17d 16h 18m
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: 17d 16h 29m
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: 17d 16h 32m
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: 17d 16h 35m
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: 17d 16h 38m
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: 17d 16h 41m
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: 17d 16h 45m
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: 17d 16h 51m
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: 17d 16h 52m
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: 17d 22h 54m
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: 18d 20h 45m
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: 19d 6h 45m
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: 20d 1h 55m
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: 20d 12h 10m
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: 22d 6h 24m
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: 22d 10h 44m
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: 22d 22h 9m
Buy It Now for only: $299.99

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: 24d 7h 55m
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: 24d 11h 40m
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: 24d 11h 58m
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: 25d 8h 19m
Buy It Now for only: $167.31

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: 26d 10h 41m
Buy It Now for only: $449.99

F 86 SABRE DUCTED FAN ARF 345 WING JET Airplane
F 86 SABRE DUCTED FAN ARF 345 WING JET Airplane
$125.00
Time Remaining: 26d 17h 47m
Buy It Now for only: $125.00

Jet Keecat 65 551 Electric or Nitro Gas Prop Jet R C RC Airplane Plane ARF
Jet Keecat 65 551 Electric or Nitro Gas Prop Jet R C RC Airplane Plane ARF
$135.99
Time Remaining: 27d 1h 30m
Buy It Now for only: $135.99

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: 27d 11h 1m
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: 27d 14h 23m
Buy It Now for only: $49.95

7 CH Super F 16 EX V2 RC EDF Remote Control Jet Airplane PNF ARF
7 CH Super F 16 EX V2 RC EDF Remote Control Jet Airplane PNF ARF
$266.35
Time Remaining: 28d 3h 21m
Buy It Now for only: $266.35

Navy Cat Turbine Jet Carbon Fiber Version ARF XY 292
Navy Cat Turbine Jet Carbon Fiber Version ARF XY 292
$399.00
Time Remaining: 28d 22h 10m
Buy It Now for only: $399.00


Comments are closed.