Ditutup

Banklink to Excel Integration

Hi,

We want to be able to access live data from Banklink software via Microsoft Excel - so effectively we need a live data connector where Excel Spreadsheets can lookup data in the Banklink database and return transaction lines, account totals etc etc.

Banklink is a piece of software and you can find details about it on their website - www.banklink.com.au. The software stores client transactional data in individual client datafiles with a *.bk5 extension - all the information we need for each client will be stored in these files.

We would want to be able to lookup data in client files from within excel to create custom reports, workpapers etc.

Ideally I am looking for someone who has had previous success with accessing data stored in Banklink client files.

I look forward to hearing form you.

Thanks!

Please provide an example of previous work you have done integrating with Banklink software. This software does not have an API or ODBC, so you would need to get into the data another way.

I have added a sample BK5 file......this is a Banklink client file (database) which contains all the transactional data.

I want to be able to do the following:
- Return a balance of an account at a specified date
- Return the net movement in an account between a specified date range
- Return actual transaction lines based on specific criteria (Date, Account Code, etc).

I have also attached a general ledger which has been generated in Banklink from that same client file to show the kind of data stored in the BK5 file.

Ideally, Excel would be able to refer to the BK5 file on a live basis. Therefore as changes are made in Banklink (and therefore the BK5 file) the changes are reflected in Excel. We have a lot of clients, and therefore we would want to access a lot of BK5 files too.

Im not exactly sure how you would interface between Excel and the BK5 files, but there would need to be some sort of lookup functionality in Excel to select what data is to come through, or alternatively, the entire contents of the BK5 file could be dumped into a pivot table and looked up from there.

Kemahiran: Kejuruteraan, Excel, Kejuruteraan Perisian

Lihat lebih lanjut: bk5, live data banklink, microsoft excel software, engineering au, accessing banklink files, banklink, microsoft spreadsheets, Excel to Access, excel reports, data integration excel, client form excel, microsoft excel account, banklink software, live data website excel, live excel data, excel live data, data integration form, excel form account, custom reports excel, create excel form integration, create reports excel database, excel create access database, excel data integration, excel integration, integration access excel

Tentang Majikan:
( 0 ulasan ) Upper Mount Gravatt, Australia

ID Projek: #4033167

3 pekerja bebas membida secara purata $500 untuk pekerjaan ini

TCNGraphicExpert

We can able to do this for, please discuss with details. Thanks

$250 AUD dalam 5 hari
(2 Ulasan)
1.9
jmcabandara

I am an expert in this field

$750 AUD dalam 7 hari
(0 Ulasan)
0.0
camuditlakhotia

I am a Qualified Chartered Accountant & can do this job properly

$500 AUD dalam 5 hari
(0 Ulasan)
0.0