• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

VB to Excel, Error: too many fields defined.

Hi

How can we resolve this vb error: too many fields defined. The database is an excel file. It works if I create 1 field.

thanks.



strRequest = "create table [pattern$] ([DateTime] time, " & _
" [SunPat] char(10),[MonPat] char(10))"

cn.Execute strRequest
0
RyanBank
Asked:
RyanBank
  • 2
1 Solution
 
alainbrydenCommented:
Could you explain somewhat further what you're trying to accomplish. Do you mean you can run the code once and it works but the second time does not?
0
 
alainbrydenCommented:
what?
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now