Hi,
I need fresh eyes to see where my syntax error is occurring.
Any assistance would be appreciate.
Mary -
CurrentDb.Execute ("CREATE TABLE tbl_FYData(PIDM Integer, " & _
-
"FY Varchar(2), " & _
-
"[PO Trans Date] DATETIME, " & _
-
"PO VARCHAR(8), " & _
-
"Index Varchar(6), " & _
-
"IndexApprAmt Varchar(4), " & _
-
"Item Integer, " & _
-
"NIGPCommCode Varchar(8), " & _
-
"NIGPDesc Varchar(150), " & _
-
"Unit Integer, " & _
-
"Qty Integer, " & _
-
"Total Integer, " & _
-
"Buyer VARCHAR(4), " & _
-
"ShipCode VARCHAR(4), " & _
-
"Orgn VARCHAR(6), " & _
-
"Account Varchar(6), " & _
-
"[PO Amt] Integer, " & _
-
"[V Type Code] VARCHAR(2), " & _
-
"[Last Name] VARCHAR(50), " & _
-
"[First Name] VARCHAR(50), " & _
-
"City VARCHAR(50), " & _
-
"State VARCHAR(50), " & _
-
"[Zip Code] VARCHAR(10), " & _
-
"[Entity Ind] VARCHAR(1))")
-
Index is a reserved keyword in SQL.
3  2177 
Index is a reserved keyword in SQL.
Thank you, totally ignored that situation, which in past, I was well aware of that error.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Thomas Jerkins |
last post by:
When I write a create table SQL statement I want to add some information about the column heading of each column.
How does the exact syntax for the create table look like (which includes this column...
|
by: Alicia |
last post by:
Does anyone know why I am getting a "Syntax error in Create Table
statement". I am using Microsoft Access SQL View to enter it. Any
other problems I may run into?
CREATE TABLE weeks
(...
|
by: Bhavesh1978 |
last post by:
hey guys.. im trying to create a table in mysql in phpmyadmin
was wondering weather is it right or wrong
CREATE TABLE `User`(
email varchar(32),
fname varchar(32),
lname varchar(32),
pass...
|
by: gregpinero |
last post by:
It's the strangest thing, I'm pulling some text out of a MySQL table
and trying to run exec on it, and it keeps giving me a syntax error,
always at the end of the first line.
Thanks in advance...
|
by: gomzi |
last post by:
I am getting an error no 150 when i try to create relationships between three tables.
Here are the statements : -
TABLE A
create table a(id1 int(7),id2 int(7),primary key (id1));
TABLE B...
|
by: tasmontique |
last post by:
Hello everyone,
I keep getting a syntax error in my update statement. The only thing that I notice is
that although the columns in my table have the same name as the fields on the form the...
|
by: nanabuch |
last post by:
Hello,
I am new to this forum, and I am a newbit in Oracle, I do have a background in MS Access, VBA, SQL server development and some Oracle backend development work.
I have been giving a task...
|
by: patriciashoe |
last post by:
I have been struggling with this update statement. At this point I get a syntax error if i go from SQL view to design view. Can anyone spot a problem?
UPDATE teacherresources AS A
SET...
|
by: Lars131 |
last post by:
I'm working on a simple form to database program but I keep encountering a syntax error with my SQL statement.
Since it's so long, I don't want to parameterize it, but I will if it's the only...
|
by: dowlingm815 |
last post by:
Hi,
In the following code, i keep getting a data conversion error at the fund field. In the code below, it takes data from a query and creates a table. It is a six digit alpha field within the...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
