Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 238
  • 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

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