Fields in access database
 

I know this is more of an access question but it does have to do with
excel.

I am trying to import/export data from excel to access. I originally
had 6 fields and they were all working beautifully. I went in and had
to add 7 more fields so i changed my tables to accomodate and when i
entered the field names in my SQL statement it broke the code. I tried
all the way down to 1 more field and it still wasnt working. Is there
a limit to how many field you can call or am i just doing something
wrong?

Thanks,.
justin

Fields in access database
 

Without seeing your SQL code or the field names you added, it is a little
hard to tell. Did you make sure there are no spaces in the field names you
added? Also, Access has several restricted words that you cannot use as
field names in an upload process (ex. Date, you would have to call it
Hire_Date, etc.). If you post a little more of your issue, someone may be
able to assist you.

--
Thx
MSweetG222



"Justin Philips" wrote:

I know this is more of an access question but it does have to do with
excel.

I am trying to import/export data from excel to access. I originally
had 6 fields and they were all working beautifully. I went in and had
to add 7 more fields so i changed my tables to accomodate and when i
entered the field names in my SQL statement it broke the code. I tried
all the way down to 1 more field and it still wasnt working. Is there
a limit to how many field you can call or am i just doing something
wrong?

Thanks,.
justin