Käynnissä

Resolve issue with ODBC data Import MS Access to MS Excel

The goal of this project is to address an error that sometimes occurs in Excel during data refresh. The solution should not be a band-aid/hack fix but a *robust model for moving cross-tab query data from Access to Excel while preserving formatting in Excel*.

We have a reporting solution which is an Access Database for generating data and a linked excel spreadsheet for displaying the data. Excel is great because users are familiar with it so it's nice to see results in excel. The data set brought into Excel is a cross-tab query. The number of columns returned by the query can fluctuate, sometimes this causes an error in Excel like 'cannot move columns off sheet' this happens even if there are only a few columns with data being returned to excel from access. The method of bringing data into excel was chosen by me because I am not a programmer and I leveraged Excel standard functionality to make this solution work. I suppose there are better methods to get the data into Excel and avoid the error that is the solution you need to provide. There are multiple sheets in the excel workbook each tied to it's own Query in the MS Access DB. This data transfer method should be reusable by all sheets, and for more sheets if they are added in future.

note I am using the word 'method' as a non-programmer in it's generic sense.

Please respond with

1.) a basic proposal of how you expect to resolve the problem, and why this is better than other methods. Don't worry I'm not trying to get info for free, I need to understand what you are doing to agree to pay you to implement it.

2.) If you are new to GAF, a business reference to confirm your ability to do the work.

Taidot: Excel, Microsoft Access, SQL, Visual Basic

Näytä lisää: resolve issue, basic data, we excel, transfer methods, set data, programmer spreadsheet, me excel, make proposal, make project proposal, generic excel, generic data access, fix hack, excel spreadsheet business, new excel, excel spreadsheet programmer, transfer data excel sheet, tied, reusable, need get excel, ms s, MS excel, trying get, excel model, excel formatting, do excel

About the Employer:
( 2 reviews ) Davis, United States

Projektin tunnus: #504393

Myönnetty käyttäjälle:

snitchell

Hi. Proposal: (if acceptable) I'd remove the access interface, and replace it with sql vai vba to run your query (NOT using ms query, only vba), and populate the worksheets. With the known amount of fields returned - Lisää

200 $ USD 5 päivässä
(1 arvostelu)
2.6

23 freelanceria on tarjonnut keskimäärin 125 $ tähän työhön

schandraram

Hello - Please see PMB for details of my bid. Thank you. Chandra Ram.

200 $ USD 3 päivässä
(136 arvostelua)
6.7
rajtuhin1

Let me review your codes. I have completed 70 Projects world-wide, and got EXCELLENT CLIENT REVIEWS in each of them. Lets discuss in pmb with more details. Thanks and Regards : TUHIN

100 $ USD 3 päivässä
(63 arvostelua)
6.3
wsh2

Greetings (Davis) California from Pennsylvania.. The correct message is "Cannot shift objects off sheet." It is difficult to discern precisely where the problem is without actually seeing the Workbook, however, I ca Lisää

149.95 $ USD 2 päivässä
(35 arvostelua)
5.8
mxicoders

Have a look for the link given below http://www.mxicoders.com/outsourcing-to-india/ Mxicoders is a leading IT solutions company to provide e-commerce, e-business and branding solutions to small and medium size bus Lisää

250 $ USD 5 päivässä
(4 arvostelua)
5.5
piyushdpatel

Hi This is Piyush Patel I have 4.5+ yrs of Exp in VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Master in import-export date in Excel. Please Check My PM

100 $ USD 5 päivässä
(17 arvostelua)
5.0
KellogITSolution

Hello Please see your PMB for details. Thanks

75 $ USD 3 päivässä
(35 arvostelua)
4.9
oFAZo

Exceptional quality & Fast work. Please refer to Profile & PMB for details. Thanks FAZ

100 $ USD 3 päivässä
(20 arvostelua)
4.9
crajeshbe

Hi Good day, Excel, Access, VBA Expert Bid. Please check PM for more details. Regards C.Rajesh B.E

200 $ USD 4 päivässä
(17 arvostelua)
4.7
YashpalSingh123

Expert Computer Engineer, Having Experience in Excel and VBA , Can Start Work on Immediately effect.

150 $ USD 3 päivässä
(3 arvostelua)
4.2
jlindo

Please check PMB.

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

working in this project,hopefully complete within a week. since i am new to GAF so i am not much aware of bidding.

50 $ USD 10 päivässä
(0 arvostelua)
0.0
CHANDRASEKARANN

WELL VERSED IN MS-ACCESS DATABASE AND ALSO IN EXCEL

100 $ USD 15 päivässä
(0 arvostelua)
0.0
sureshpl

Hi! I have gone through your requirement and i am glad that i can accomplish this task, i would be more interested to speak to you on IM. Pls give us an opportunity to work with you.

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

I am expertised in Excel, Access and VB. I have 15 Yrs experince. I think that the problem can be solved by using VB macro in Excel.

99 $ USD 5 päivässä
(0 arvostelua)
0.0
tgyurjyan

Hi, The task fits in my skills and experience. Looking forward to work on this and provide the expected results. Thank you

100 $ USD 3 päivässä
(0 arvostelua)
0.0
pushpatil

Hi................

200 $ USD 15 päivässä
(0 arvostelua)
0.0
tichca

Hi, I can do this work ... please allow me to do it .. let's get started asap. Please see PMB. thanks, ted

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

would be able to devote many hours per day to this task. Perhaps anything upto 12, and pride myself on giving full and accurate results. I have no trouble performing repetitive work and provide results at the fastest Lisää

100 $ USD 1 päivässä
(0 arvostelua)
0.0
mshamir

I THINK YOU SHOULD SEND ME THE CODES, I MEAN THE ACCESS FILE AND THE EXCEL SHEET THAT HAS A PROBLEM, I WILL FIRST TRY AT MY END AND LET YOU KNOW, THEN WE WILL STRIKE A DEAL. THE BEST SOLUTION I FOUND AT THIS STAGE.

112 $ USD 6 päivässä
(0 arvostelua)
0.0
devitchandran

already working with this

50 $ USD 7 päivässä
(0 arvostelua)
0.0