Exporting table error

[commanderrico]

Ok, I created a command button to export a query to excel. I entered some data to test and make sure it work. There are 25-30 fields or so in the table and after I entered 3 records and pressed the button it exported to excel perfectly. Then I went through and entered 31 records, one for each day of July, and tried exporting it and it came back with a "too many fields present" error message. The table isn't all that big and I'm cunfused because it worked the first time I tried and I don't think that 31 records is all that much. Can someone help? Thanks

Rico

 

[JeremyNYC]

Rico,

Show us the code, and the sql to the query. If you're using a macro instead of code, convert the macro to code and include that.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Professional Development for Clients Large and Small

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.