/*
CREATE TABLE dbo.udtGeoDataStore(
    objectid int PRIMARY KEY NOT NULL,
    county int NULL,
    town int NULL,
    townpart decimal(10,2) NULL,
    towndir varchar(1) NULL,
    range int NULL,
    rangepart decimal(10,2) NULL,
    rangedir varchar(1) NULL,
    secnumber int NULL,
    qtr varchar(1) NULL,
    qtrqtr varchar(1) NULL,
    anomaly varchar(2) NULL,
    mapsuftype varchar(1) NULL,
    mapnumber varchar(20) NULL,
    ormapnum varchar(24) NULL,
    taxlot varchar(5) NULL,
    specialint varchar(5)NULL,
    maptaxlot varchar(25) NULL,
    ortaxlot varchar(29) NULL,
    taxlotacre decimal(10,2) NULL,
    mapacres decimal(10,2) NULL,
    reliacode int NULL,
    autodate datetime NULL,
    automethod varchar(3) NULL,
    autowho varchar(30) NULL,
    mapclass varchar(1) NULL,
    maprelcode varchar(2) NULL,
    mapsufnum int NULL   
) */
--  ------------------------------------------------------------------
--INSERT INTO dbo.udtGeoDataStore
SELECT 
    objectid,
    county,
    town,
    townpart,
    towndir,
    range,
    rangepart,
    rangedir,
    secnumber,
    qtr,
    qtrqtr,
    anomaly,
    mapsuftype,
    mapnumber,
    ormapnum,
    taxlot,
    specialint,
    maptaxlot,
    ortaxlot,
    taxlotacre,
    mapacres,
    reliacode,
    autodate,
    automethod,
    autowho,
    mapclass,
    maprelcode,
    mapsufnum
FROM
    OPENROWSET('Microsoft.Jet.OLEDB.4.0','W:\Wheeler County From State\WheelerCountyWide.mdb'; 'admin'; '', whee_DBO_Taxlot)

quote:

---

Msg 7308, Level 16, State 1, Line 34
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.

---