If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

define excel table in vb 2005 using oledb excel file

Hi, i am making an application that will use a access database and an excel spread sheet. It will basically save data from mutiple text box inputted by the user into both excel and access. The part of the application i need help with is below what i am trying to do is learn how to define the table in the excel tables. I have looked around and have had no progress with defining tables field. Below i have included in the comments the definition type for each column. If possible I would like to have a complete list of excel definition for the field I can use with excel oledb. Any help will be surely appreciated. thx.

here are some examples

basically what i what to happen is the code above will check to see if the excel.xls file is there. Using this commandline it will create the table and the data type for each column.

so basically i am trying to create a excel.xls file with so many column and just like when you are creating an access.mdf or sql.mdf file you have to to name the data type for the like below i only what to learn how to set the data type for the columns. --> e.g. name varchar(20).....etc. I know how to set the data type for access.mdf file what i am trying to find out is what are the data types for excel files.

time(time) ?
date(date)?
name varchar(20)? or name(text)? or name memo? don't really know what data type are used for excel.xls file

Here is an update that will show what happens

hi,

I having problem with a oledb project. What i am trying to do is to be able to create a excel workbook and read data into the field. The below code the first section the code causes an error saying "santax error in field definition". The second part make the file but when i try to open it in excel it say its a corupt or invalid format. If any one know anything about this and can help me i would sure appreciate it.

Just an FYI, Excel supports a subset of the Jet data types. There are certain data types and properties that will not be supported under Excel. Excel supports Double, Date, Currency, YesNo (Boolean), Text and Memo.

concerning format

hi,

well I trying to figure out the yes/no value how do i write that?

Also I have one last question, I am using a calendar when i select a date it will fill mutiple single lined textboxes with the values, including a time comboBox, i what to happen is after i select a date using the calendar, I want to be able to select the interviews by time.

The way i have it set up now is when i do the above it show the info for the for the time, but the original times that were filled into the comboBox disappear. So then i would have to reselect the date all over again reselect the time. I want be able to select the time and be able to select another time with out having to reselect the date al over again just to get the information for that schedule time for that day.