ok so i figured out how to load an excell file in to a dataset

but i need to be able to save this file in the same format as the table that
i have created in memory how is this done ?

WStoryeII

Hi WStorey,

I think only by looping through it

Not to difficult when you know that this is almost a generic routine roughly
as pseudo

\\\
for i as integer = 0 to myexcelDS.tables(0).rows.count - 1
dim dr as datarow = dsmem.tables(0).newrow
dr("myfirstfield") = myexcelds.tables(0).rows(i)(0)
dr...............
dsmem.tables(0).rows.add(dr)
next
///

I hope this helps?

Cor

Hi WStorey,

There was asked it your last problem if it was that Excel 9. I was also
thinking that that could be the problem, will you please answer that kind of
questions?

Otherwise answering you has no sense, sometimes the one who answers, want to
learn also from the problems you know?.

Cor

yes it worked i am sorry about that i just have been frustreated trying to
fix this and i forgot to reply

thank youmuch
wstoreyII

"Cor" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi WStorey,
>
> There wa
s asked it your last problem if it was that Excel 9. I was also
> thinking that that could be the problem, will you please answer that kind
of
> questions?
>
> Otherwise answering you has no sense, sometimes the one who answers, want
to
> learn also from the problems you know?.
>
> Cor
>
>