Käynnissä

Connect to multiple Access Querys from within Excel

Access/Excel 2010

I need a better way to access multiple queries when I'm in excel.

In access I have several tables linked to csv files

I then manipulate that data using a variety of queries.

Finally, in Excel, i use the "get external data" wizard to access these queries and excel and and then place them in separate excel sheets in one excel file.

This should work and does only about 75% of the time. Looking online, i've seen other people complain about this.

The problem is it constantly bugs out. I think the problem relates to the fact that in one excel sheet i have different queries populating the different excel sheets. As a result, as each query accesses the db it ties it up and the excel tries to move on to the next query, but can't. I then get an error saying the db is read only and everything stops.

Solution: I think the solution is to use something outside of the excel wizard, maybe via odbc, and set it up to access each query, then release the db, and then move on to the next query and so on...

I'm open to suggestions and thoughts.

I can pay $30 for this project - with a $30 bonus if the solution permanently solves this problem.

Taidot: Excel, Microsoft Access

Näytä lisää: open excel online, microsoft excel online, get external data, use excel online, open csv file online, microsoft access online, complain , separate excel data sheets, set within, access project 2010 2013, project 2013 access, connect excel sheets, access query excel, move data excel, excel csv online, excel manipulate data, connect using, 2013 query, excel query csv file, microsoft excel 2013, read excel file sheet, time sheets excel, project using access excel, access data project 2013, read multiple data excel

About the Employer:
( 156 reviews ) Saipan, United States

Projektin tunnus: #4267890

Myönnetty käyttäjälle:

Premshanks

I can create ms excel vba to solve this for you. pl approve regards Prem

30 $ USD 5 päivässä
(179 arvostelua)
6.0

10 freelanceria on tarjonnut keskimäärin 42 $ tähän työhön

NourElDeen

Dear Sir, I'm Expert with access. Best Regards, NourElDeen

30 $ USD 4 päivässä
(18 arvostelua)
4.1
vikashgadia

excel vba expert to help u.

30 $ USD 2 päivässä
(13 arvostelua)
3.5
epdailo

I would like to help you on this. See my PM

30 $ USD 7 päivässä
(2 arvostelua)
2.2
srdas2012

Hello Sir We are Expert in Acceess ,We can solve your Problem,Please See Private Message.

30 $ USD 3 päivässä
(2 arvostelua)
2.1
evidyarthi

Hi, I have experience working on this kind of projects please check PMB

60 $ USD 5 päivässä
(1 arvostelu)
1.4
kapoorprateek82

Hello, I am a .net programmer and I can give you a dotnet standalone application which can read the data from access queries and export it to your already formatted blank excel file or it can create new excel file. If Lisää

120 $ USD 5 päivässä
(2 arvostelua)
1.0
santo18186

Sir i can do this project.

30 $ USD 10 päivässä
(0 arvostelua)
0.0
coldbeersoldhere

Please check PMB

30 $ USD 1 päivässä
(0 arvostelua)
0.0
geeki

Please check PMB

30 $ USD 2 päivässä
(0 arvostelua)
0.0