All,
Please help me with following error. I am using classic ASP to connect
to MS Access DB to create a table dynamically. Following is the table
definition. I get the error when I execute the following SQL.
CREATE TABLE [Exceptions] ( [ID] [Number] NULL , [LegalEntityID]
[Number] NULL , [CompanyID] [Number] NULL , [DivisionID] [Number] NULL
, [LocationID] [Number] NULL , [Level1ID] [Number] NULL , [QNQLevel1ID]
[Number] NULL , [QNQLevel1YRID] [Number] NULL , [Level2ID] [Number]
NULL , [QNQLevel2ID] [Number] NULL , [QNQLevel2YRID] [Number] NULL ,
[VendorID] [Number] NULL , [CostCenterProjectID] [Number] NULL ,
[CostCenterProjectAllocationID] [Number] NULL , [EmployeeID] [Number]
NULL , [QNQVendorID] [Number] NULL , [QNQVendorGlobalID] [Number] NULL
, [QNQExpClassID] [Number] NULL , [QNQActivityCodeID] [Number] NULL ,
[QNQVendorExpClassID] [Number] NULL , [QNQSubExpClassID] [Number] NULL
, [QNQMisc1ID] [Number] NULL , [LegalEntityNumber] [Text] NULL ,
[LegalEntityName] [Text] NULL , [Company] [Text] NULL , [CompanyName]
[Text] NULL , [State] [Text] NULL , [Location] [Text] NULL ,
[DivisionNumber] [Text] NULL , [DivisionName] [Text] NULL ,
[Level1Number] [Text] NULL , [Level1Description] [Text] NULL ,
[LevelType] [Number] NULL , [Level2Number] [Text] NULL ,
[Level2Description] [Text] NULL , [VendorNumber] [Text] NULL ,
[VendorName] [Text] NULL , [VendorType] [Text] NULL , [ExpClass] [Text]
NULL , [ExpClassDescription] [Text] NULL , [SubExpClass] [Text] NULL ,
[SubExpClassDescription] [Text] NULL , [ActivityCode] [Text] NULL ,
[ActivityCodeDescription] [Text] NULL , [QNQMisc1Number] [Text] NULL ,
[QNQMisc1Description] [Text] NULL , [InvoiceNumber] [Text] NULL ,
[InvoiceDescription] [Text] NULL , [Year] [Number] NULL , [Date] [Text]
NULL , [FedW2] [Number] NULL , [NewStandardHours] [Number] NULL ,
[Hours] [Number] NULL , [TotalProjectHours] [Number] NULL , [PayrollID]
[Number] NULL , [StateID] [Number] NULL , [Misc1] [Text] NULL , [Misc2]
[Text] NULL , [Misc3] [Text] NULL , [Misc4] [Text] NULL , [Misc5]
[Text] NULL , [Misc6] [Text] NULL , [Misc7] [Text] NULL , [Misc8]
[Text] NULL , [Misc9] [Text] NULL , [Misc10] [Text] NULL ,
[OriginalAmount] [Number] NULL , [CalculatedAmt] [Number] NULL ,
[Amount] [Number] NULL , [RecordID] [Number] NULL , [Mapped] [Text]
NULL , [41PercentLevel1] [Number] NULL , [41PercentLevel1QNQ] [Text]
NULL , [41PercentLevel1YR] [Number] NULL , [41PercentLevel1YRQNQ]
[Text] NULL , [41PercentExpClass] [Number] NULL ,
[41PercentExpClassQNQ] [Text] NULL , [41PercentInvoice] [Number] NULL ,
[41PercentInvoiceQNQ] [Text] NULL , [41PercentLevel1L] [Number] NULL ,
[41PercentLevel1K] [Number] NULL , [41PercentLevel1S] [Number] NULL ,
[41PercentLevel1YRL] [Number] NULL , [41PercentLevel1YRK] [Number] NULL
, [41PercentLevel1YRS] [Number] NULL , [ExpType] [Text] NULL ,
[Level1Percent] [Text] NULL , [41PercentVendor] [Number] NULL ,
[41PercentVendorQNQ] [Text] NULL , [41PercentVendorGlobal] [Number]
NULL , [41PercentVendorGlobalQNQ] [Text] NULL , [ImportError] [Text]
NULL , [ImportErrorDesc] [Text] NULL)
I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Column or parameter #1:
Cannot find data type Number.
When I go to MS Access and paste the above Create Table difinition, I
get the same error that I have a syntax error at [Number]. I even
tried creating simple tables using CREATE TABLE syntax, but always get
the same error.
Please help me solve it.
Thanks in advance,
Boris