Change the Input Excel sheet

[laurasesma18]

I've got a convertion tool with Access 2003. It imports an excel sheet
into the data base and with the records in it
creats different outputfiles. Its programmed with VBA.
Now what I need is, in some cases, to change the excel sheet that we
import. How should I do that? If anyone can give me an advise it would
be great. Thank you.

[pamela fluente]

On 1 Ott, 16:40, [e-mail] wrote:

I've got a convertion tool with Access 2003. It imports an excel sheet
into the data base and with the records in it
creats different outputfiles. Its programmed with VBA.
Now what I need is, in some cases, to change the excel sheet that we
import. How should I do that? If anyone can give me an advise it would
be great. Thank you.

This free tool allows you to change at will
the sheet to import. You can also
make any union or joins of different sheets, even belonging
to different Excel files. Or joining an excel sheet with an access
table.
http://www.datatime.eu/download.aspx

If you have problem can write directly to me.
-P

[The Frog]

Hi Laura,

It is easy to get the 'table names' from an excel sheet if you are
using ADO code:

dim cnn as ADODB.Connection
dim cat as ADOX.Catalog
dim tbl as ADOX.Table

SET cnn = NEW ADODB.Connection
With cnn 'FileName is the name of the file you want to open
[String]
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source = " & FileName & "; Extended
Properties = Excel 8.0;"
.Open
End With

Set cat = New ADOX.Catalog 'get the Catalog Information connected
up
cat.ActiveConnection = cnn

for each tbl in cat.Tables
debug.print tbl.Name
next

set cat = Nothing
cnn.Close
set cnn = Nothing

You can also get to the field names and definitions for each table by
using the ADOX.Column data type for a variable and iterating through
the 'columns' for each table.

Named ranges will also show up using this method, but not Dynamic
Named Ranges. Sometimes Excel will also give a sheetname with a "_"
character or a "$" character at the start - I usually just filter
these out with a simple if statement if I want to make a list of the
available tables and named ranges.

I hope this helps

Cheers

The Frog

[Keith Wilby]

<la**********@gmail.comwrote in message
news:11**********************@22g2000hsm.googlegro ups.com...

I've got a convertion tool with Access 2003. It imports an excel sheet
into the data base and with the records in it
creats different outputfiles. Its programmed with VBA.
Now what I need is, in some cases, to change the excel sheet that we
import. How should I do that? If anyone can give me an advise it would
be great. Thank you.

Use this:

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

Keith.
www.keithwilby.com

[laurasesma18]

Thank you all for your help. With all the information I've got now,
I'm going to try to do it.
If I have any specific problems I will tell you.
Thank you again,

Laura