Problema de sintaxis

[flacoluis]

fijate si no se da algunos de estos casos:

The problem is with the table itself and how the columns are defined. You
will get an "Error in Row" error anytime the following situations occur:

1. Any text column is blank. When you define a column in Access, the
default value for "allow zero length" is No (which IMHO is totally stupid)
which means the column must have data. I always have to change this
to "Yes". Too bad Microsoft won't say "column can't have zero length".

2. Any time the data for a text column is too long. If you define a
FirstName column as 20 characters and you try to stuff in a 30-character
name, you will get this error. Too bad Microsoft won't say "data string
too long for this column".

3. Any time a column has indexing set to "Yes (No Duplicates)". This might
be the problem you are having with the long integer column, especially if
this column is a foreign key to another table that uses an AutoNumber
column as it's primary key. Too bad Microsoft won't say "duplicte entry
for this column".

If you are not familiar with how all the columns are defined, this "Error
in row" message will drive you bonkers.

espero te sirva