473,322 Members | 1,493 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Too many fields defined

I am trying to export a table to Excel using transferspreadsheet and I am
running into the "Too many fields defined" error. There are 31 columns in
the table. The export worked previously and it bombed out last night with
the above error. I tried compact and repair and also redid the whole
database from scratch and it still bombed. Any assistance would be greatly
appreciated.

Thanks,
Pat
Jun 27 '08 #1
1 4145
Pat_RI wrote:
I am trying to export a table to Excel using transferspreadsheet and I am
running into the "Too many fields defined" error. There are 31 columns in
the table. The export worked previously and it bombed out last night with
the above error. I tried compact and repair and also redid the whole
database from scratch and it still bombed. Any assistance would be greatly
appreciated.

Thanks,
Pat

It thinks you are attempting to send more than 255 columns. Maybe
create a temp query on the table and start deleting 1 column at a time
after running the command then run until you find the column that is
causing problems.

Another thing, you can post your Docmd.TransferSpreadsheet line here so
that others can review it and see if you are using an incorrect syntax.

Three More Days
http://www.youtube.com/watch?v=bIYG4wvRXVk
Jun 27 '08 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: NotGiven | last post by:
I have display error ON and error reporting to E_ALL. I have a form that opens fine. When you submit it, all the fields that have nothing in them, for example an un-selected radio button, throw...
2
by: shivprasad koirala | last post by:
hi all(happy raksha bandhan day) we have one of Automation software for sales running for a customer.He was cool for the first month of product, but later popped with adding some extra...
3
by: Lars Rune Nøstdal | last post by:
struct X { unsigned int a : 1; unsigned int b : 1; }; int main() { X* x = new X; x->a = 1; x->b = 1;
2
by: | last post by:
does anyone know what is the maximum number of fields that can be updated at once in access 2000 i am updating approx. 150 at once and keep getting this error: Microsoft JET Database Engine error...
0
by: Fercat | last post by:
Hi! I receive in an Outlook mail folder some custom forms that contain user defined fields (for example, Client Name, Contract Number...). The problem is that when I finish linking this folder...
112
by: Carsten Hansen | last post by:
Suppose I'm using an implementation where an int is 16 bits. In the program below, what function is called in the first case, and what is called in the second case? Also, if there is a difference...
10
by: Abhi | last post by:
In ANSI C, we can have a bit fields inside structure like struct _A { int i:2; }; would define a variable of 2-bit length. My doubt is that what would the size of this structure then? Would...
26
by: julien | last post by:
Hello, I don't know when to use fields and when to used properties. It looks to me that using properties is always better. But I guess fields must be better in some cases, otherwise they wouldn't...
12
by: M G Henry | last post by:
I have a tabbed form that contains 12 different "pages" and when I try and run the form I get the error message too many fields defined --- which I believe is the 255 field limit in the record...
14
by: Thurston Manson | last post by:
Suppose I'm using an implementation where an int is 16 bits. In the program below, what function is called in the first case, and what is called in the second case? Also, if there is a difference...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.