R
Raiju
Hi,
How do I link multiple excel files into single access table
Regards,
Raiju
How do I link multiple excel files into single access table
Regards,
Raiju
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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
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
A
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
applicable.
I'd just move to SQL Server and learn a real ETL tool like DTS or SSIS
-Aaron
P
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.
K
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.
answering your question. Continue to consider her advice in this thread.
G
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
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
K
Ken Snell MVP
Gina Whipp said: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!
R
Raiju
i didn't understand anything
Ken Snell MVP said: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/
G
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
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
R
Raiju
I don't have much knowledge in writing macro, can you provide with the codes
where i can change the path & file names.
where i can change the path & file names.
G
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
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