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.

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
$219.52
Time Remaining: 1d 4h
Buy It Now for only: $219.52

F 16 Jet Fighter RED and WHITE ARF Pusher Design USAF R C Nitro or Electric 41
F 16 Jet Fighter RED and WHITE ARF Pusher Design USAF R C Nitro or Electric 41
$229.99
Time Remaining: 1d 11h 46m

SUPER HUGE 1M RC F117 Nighthawk ARF Model Jet Plane Vehicle Aerobatic 64MM EDF
SUPER HUGE 1M RC F117 Nighthawk ARF Model Jet Plane Vehicle Aerobatic 64MM EDF
$250.99
Time Remaining: 2d 16h 28m
Buy It Now for only: $250.99

SUPER HUGE RC YF23 ARF Model Jet Plane Vehicle Aerobatic Twin EDF
SUPER HUGE RC YF23 ARF Model Jet Plane Vehicle Aerobatic Twin EDF
$535.00
Time Remaining: 3d 19h 18m
Buy It Now for only: $535.00

SUPER HUGE 15M RC F18 Red ARF Model Jet Plane Twin EDF
SUPER HUGE 15M RC F18 Red ARF Model Jet Plane Twin EDF
$699.99
Time Remaining: 3d 21h 15m
Buy It Now for only: $699.99

SUPER HUGE 15M RC F18 Grey ARF Model Jet Plane Twin EDF
SUPER HUGE 15M RC F18 Grey ARF Model Jet Plane Twin EDF
$699.99
Time Remaining: 3d 21h 51m
Buy It Now for only: $699.99

SUPER HUGE15M RC SU47 Berkut ARF Model Jet Plane Vehicle Twin EDF
SUPER HUGE15M RC SU47 Berkut ARF Model Jet Plane Vehicle Twin EDF
$480.00
Time Remaining: 3d 23h 35m
Buy It Now for only: $480.00

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: 4d 13h 46m
Buy It Now for only: $299.99

SUPER HUGE RC SR71 Blackbird ARF Model Jet Plane Vehicle Aerobatic Twin EDF
SUPER HUGE RC SR71 Blackbird ARF Model Jet Plane Vehicle Aerobatic Twin EDF
$345.00
Time Remaining: 4d 16h 50m
Buy It Now for only: $345.00

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 4h 8m
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 18h 20m
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 4h 42m
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 7h 43m
Buy It Now for only: $129.98

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: 9d 3h 27m
Buy It Now for only: $599.00

Super Falcon V3 Turbine Jet ARF XY 189
Super Falcon V3 Turbine Jet ARF XY 189
$299.00
Time Remaining: 9d 14h 19m
Buy It Now for only: $299.00

RC Airplane Kit USA Tom Hawk Prop Jet 61 size 54 Wingspan ARF
RC Airplane Kit USA Tom Hawk Prop Jet 61 size 54 Wingspan ARF
$239.95
Time Remaining: 10d 8h 33m
Buy It Now for only: $239.95

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 18h 5m
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: 11d 2h 23m
Buy It Now for only: $659.00

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 5h 16m
Buy It Now for only: $99.00

GREAT PLANES ElectriFly F 20 Tigershark Jet EDF ARF
GREAT PLANES ElectriFly F 20 Tigershark Jet EDF ARF
$105.69
Time Remaining: 12d 6h 44m
Buy It Now for only: $105.69

GREAT PLANES ElectriFly Evader EDF EP Sport Jet ARF
GREAT PLANES ElectriFly Evader EDF EP Sport Jet ARF
$167.79
Time Remaining: 12d 6h 48m
Buy It Now for only: $167.79

RC Floater Jet EPO ARF
RC Floater Jet EPO ARF
$52.44
Time Remaining: 14d 11h 10m
Buy It Now for only: $52.44

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 4h 54m
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 3h 52m
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
$199.00
Time Remaining: 16d 14h 48m
Buy It Now for only: $199.00

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 17h 49m
Buy It Now for only: $299.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 18h 9m
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 18h 44m
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 18h 54m
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 18h 58m
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 19h 1m
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 19h 4m
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 19h 7m
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 19h 11m
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 19h 16m
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 19h 18m
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: 18d 1h 20m
Buy It Now for only: $419.99

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

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
$636.00
Time Remaining: 18d 23h 11m
Buy It Now for only: $636.00

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 14h 35m
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 8h 49m
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 13h 10m
Buy It Now for only: $479.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 10h 21m
Buy It Now for only: $518.00

NEW Great Planes F 20 Tigershark Jet w Motor ARF 225 GPMA1875 NIB
NEW Great Planes F 20 Tigershark Jet w Motor ARF 225 GPMA1875 NIB
$84.98
Time Remaining: 25d 3h 31m
Buy It Now for only: $84.98

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 10h 45m
Buy It Now for only: $167.31

SUPER HUGE 151M RC F22 Raptor ARF Model Jet Plane Twin EDF Motor
SUPER HUGE 151M RC F22 Raptor ARF Model Jet Plane Twin EDF Motor
$529.00
Time Remaining: 26d 7m
Buy It Now for only: $529.00

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

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 13h 7m
Buy It Now for only: $449.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 13h 27m
Buy It Now for only: $229.99

Air Earl RC Jet R C HL Airplane Full Function ARF Flight Easy to Fly Plane
Air Earl RC Jet R C HL Airplane Full Function ARF Flight Easy to Fly Plane
$94.66
Time Remaining: 27d 19h 1m
Buy It Now for only: $94.66

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 14h 4m
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 14h 18m
Buy It Now for only: $98.99


Comments are closed.