Excel Files

[Raiju]

Hi,

How do I link multiple excel files into single access table

Regards,
Raiju

 

[Gina Whipp]

Raiju,

You can't BUT you can link to the multiple Excel files and append to one
Access table. You can run code to do so via a macro or VBA connect to a
command button or some other trigger on a form.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[aaron.kempf]

I would ignore Gina, her answer is to use Jet, no matter how
applicable.

I'd just move to SQL Server and learn a real ETL tool like DTS or SSIS

-Aaron

 

[Piet Linden]

I would ignore Gina, her answer is to use Jet, no matter how
applicable.

I'd just move to SQL Server and learn a real ETL tool like DTS or SSIS

-Aaron

Why, because she answered the question that the poster asked? Your
dogmatism isn't helping.

 

[Ken Snell MVP]

Gina speaks with tremendously more wisdom than Aaron with respect to
answering your question. Continue to consider her advice in this thread.

 

[Gina Whipp]

Thanks! I'm trying y best to ignore Aaron as it seems that (as mentioned by
Chris) he seems to enjoy distracting all from actully answering the OP's
question.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Ken Snell MVP]

Thanks! I'm trying y best to ignore Aaron as it seems that (as mentioned
by Chris) he seems to enjoy distracting all from actully answering the
OP's question.

One need not give any time or consideration to entities that are just full
of hot air and venom..... and I don't give him any time or consideration
either!

 

[Raiju]

i didn't understand anything

One need not give any time or consideration to entities that are just full
of hot air and venom..... and I don't give him any time or consideration
either!
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

 

[Gina Whipp]

Raiju, are you syaing you don't understand the below statement?

You can't BUT you can link to the multiple Excel files and append to one
Access table. You can run code to do so via a macro or VBA connect to a
command button or some other trigger on a form.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Raiju]

I don't have much knowledge in writing macro, can you provide with the codes
where i can change the path & file names.

 

[Gina Whipp]

Raiju,

There is no code to write to link to the Excel spreadsheets...

You open the database go to File... Get External Data... Link Tables...
Once the window opens up navigate to the Excel Spreadsheet. Do this for
each Excel Spreadsheet. Once done create a table with all the appropiate
fields to append all the spreadsheets to. Then all you will need is some
append queries but let's get thru the linking first.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm