View Single Post
  #4 (permalink)  
Old 12-03-2008, 8:52 AM
cjard's Avatar
cjard cjard is offline
VB.NET Forum All-Mighty
.NET Framework: .NET 2.0 (VS 2005)
 
Join Date: Apr 2006
Age: 65
Posts: 6,442
Reputation: 807
cjard has a reputation beyond reputecjard has a reputation beyond reputecjard has a reputation beyond reputecjard has a reputation beyond reputecjard has a reputation beyond reputecjard has a reputation beyond reputecjard has a reputation beyond reputecjard has a reputation beyond reputecjard has a reputation beyond reputecjard has a reputation beyond reputecjard has a reputation beyond repute
Default

Confusing. Anyway:

ConnectionStrings.com - Forgot that connection string? You will find it right here! - get a conn str for your excel file, read it with the MS Access DB Driver

Read into a weakly typed datatable

Transfer into another strongly typed datatable you made, linked with the database. FOllow the instructions in the DW2 link in my signature, section Creating a Simple Data App for more info

No need to d/l from the db because you already have all the info in the strongly typed datatable

Write the datatable to a file
__________________
DW1 DW2 DW3 DW4 DNU PQ
Reply With Quote