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
RyanBankAsked:
Who is Participating?
 
alainbrydenConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.