importing excel spreadsheets

[Dave]

Once again, I'm stumped, and my brain hurts.

I need to import data from excel spreadsheets into a database I'm
building. This will be done on different files almost daily. These
files will all be the same in structure but unfortunately I cannot use
an import specification for importing spreadsheets. I also know how to
call a common dialog API to select the appropriate file. The trouble
comes in the design of the .xls files. Unfortunately, the field names
are in the 8th row, the data is in 10 different columns but I only
want 3 of those columns. How can I import only certain cells into my
table? For example the cells I want will be in A9:A48, C9:C48, F9:F48,
A52:A96, C52:C96 and F52:F96. With columns A, C and F being the fields
to match my table.

Also, is there a problem with text and numbers when importing excel
into access?

Thanks in advance,

Dave B

 

[Pieter Wijnen]

This might help

http://support.microsoft.com/kb/257819

HTH

Pieter

 

[Dave]

This might help

http://support.microsoft.com/kb/257819

HTH

Pieter










- Show quoted text -

There is some good information there, but it doesn't speak about
importing into access. Perhaps I have to dig deeper into the article.
Thanks Pieter