import multiple files into Excel

[Johny1900]

Hi everybody,

I need to import about 1500 HTML file into a DB (SQL Server). But (here is the big problem), I only need to import some data of each HTML file (always the same line/variable).
So I thought using Excel as you can say with part of the HTML file you want to import. It works great.
But I did it with one file. Is there a way you can select a whole directory and it does it for you?

Many thx

Johny

 

[Ithyan]

Hi Cindy,
Still couldn't figure out on this.
Request your suggestions...

Cheers,
Ithyan.

 

[wagnersiquara]

Hello Cindy Ellis
okay?
First parabinizo the code it is actually very useful.
using this code, I need help to do the following:
When you import the file have the option to choose which line will be imported, fine.
But when it matters I would like to informing you finish to which column I'll send the line imported.
Ex: Excel
A B C
2 xx000x 8073 123456
3 xx000x 8074 123457
etc
=====================================================
Olá Cindy Ellis,
tudo bem ?
Primeiro parabinizo pelo código ele é realmente muito util.
utilizando esse codigo, eu preciso de ajuda para fazer o seguinte:
Ao importar o arquivo temos a opção de escolhar qual linha será importada, ótimo.
Porém ao importar eu gostaria de infomar para qual coluna eu vou enviar a linha importada.
Ex: Excel
A B C
2 xx000x 8073 123456
3 xx000x 8074 123457
etc