View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Exporting excel worksheet to access table

Access has a builtin capability to import and Excel spreadsheet - that
might be easier to use.

While not C#, you can look at Mr. Erlandsen's site for working with Excel,
Access and ADO. (not ADO.Net)


http://www.erlandsendata.no/english/...php?t=envbadac

You might search the knowledgebase for examples specific to C#.

http://support.microsoft.com

select advanced search.

--
Regards,
Tom Ogilvy


"Narwe" wrote in message
...
I have an excel worksheet with defined columns that i need to export to a
access database with identical column headings. I can get as far as
importing my worksheet into a dataset, but im not really sure where to go
from there. For that matter, I'm not even sure if this is the right forum

to
be posting in :( Any help would be greatly appreciated.

Oh yeah, I'm using c#.

Thanks