Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
DotNet
acad.assignment.mngr
academic
adonet
aspnet
aspnet.announcements
aspnet.build.controls
aspnet.caching
aspnet.datagridcontrol
aspnet.mobile
aspnet.security
aspnet.webcontrols
aspnet.webservices
clr
compactframework
component_services
datatools
distributed_apps
drawing
faqs
framework
framework.wmi
general
internationalization
interop
languages.csharp
languages.jscript
languages.vb
languages.vb.controls
languages.vb.data
languages.vb.upgrade
languages.vc
languages.vc.libraries
myservices
odbcnet
performance
remoting
scripting
sdk
security
setup
vjsharp
vsa
webservi.enhancements
webservices
windowsforms
windowsforms.controls
winforms.databinding
winforms.designtime
xml
  
 
date: Tue, 22 Apr 2008 01:07:26 -0700 (PDT),    group: microsoft.public.dotnet.datatools        back       


Excel and OleDbDataAdapter. How can i ignore blank columns.   
Hi,

I have an application, that needs to import excel spreadsheets into a
database.

I am using an OleDBDataAdapter to load (fill) the data into a Dataset.

Occasionally, person sending us the file, will put the data starting
in column B, not column A.    This fails our checks on column count.
(Also occasionally, an extra blank column after the data gets read
in).

Is there an easy way for me to get the DataAdapter to ignore blank
columns?

Rollasoc
date: Tue, 22 Apr 2008 01:07:26 -0700 (PDT)   author:   Rollasoc

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us