Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Database fields in Excel? | New Users to Excel | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
Query of an Access database won't let me get more than 95 fields. | Excel Discussion (Misc queries) | |||
Fields in access database | Excel Programming | |||
Help: pivot chart data in secured Access database wont show fields | Charts and Charting in Excel |