Bringing Excel worksheet data into a Temp Table

[UNDPC]

Hi,
I am trying to create a macro that creates a temporary table in Access and then imports data from an Excel worksheet. When I run the "RunSQL" command to execute my CREATE TABLE statement, I am getting a syntax error. I thought my statement was correct, and I cannot see what is wrong. Anyone see it?

CREATE TABLE Current_Period_Checks (Payor TEXT, GL_Number NUMBER(Long), Borrower_ID_Number NUMBER(Long), CAM_Date DATE/TIME, Check_Cleared_Date DATE/TIME, Disallowed_Date DATE/TIME, Amount NUMBER(Double), Account NUMBER(Decimal), Comment TEXT);

 

[galileeian]

you may find it easyer to create the table yourself manually. You can then delete all the rows in one query, then import the data in the next query.