J
jbwerner
We are using Access 2002. I’m using Access to take 30 Excel spreadsheets and
combine them into one. Each spreadsheet is linked as an Access table. Then
I use an Append query to combine them into one. The Excel spreadsheets are
updated every month via Active sync. Each salesman has a handheld and they
sync this spreadsheet to a network folder. When I run the macro that runs
all the queries, I get a “to many fields defined†error. When I look at
the table in Access it has 256 columns in it. When I look at the Excel
spreadsheet it has 13 columns. To fix the problem all I have to do is open
the Excel spreadsheet and click save then the Access table only shows 13
columns. I could write it off as an Active Sync issue, but it doesn’t to it
to all the spreadsheets. About 25 out of 30 have this problem.
combine them into one. Each spreadsheet is linked as an Access table. Then
I use an Append query to combine them into one. The Excel spreadsheets are
updated every month via Active sync. Each salesman has a handheld and they
sync this spreadsheet to a network folder. When I run the macro that runs
all the queries, I get a “to many fields defined†error. When I look at
the table in Access it has 256 columns in it. When I look at the Excel
spreadsheet it has 13 columns. To fix the problem all I have to do is open
the Excel spreadsheet and click save then the Access table only shows 13
columns. I could write it off as an Active Sync issue, but it doesn’t to it
to all the spreadsheets. About 25 out of 30 have this problem.