Đang Thực Hiện

165139 Access/Excel Project

I'd like to be able to import records into a table (PREMPBALANCES) from an excel spreadsheet with set column

headings. The user interface should be as simple as a button that says ‘Import YTD Balances' and then allows selection of *.xls file. The system would look to see if the [url removed, login to view] and [url removed, login to view] exist, if not the system will append the record with the information in the excel spreadsheet. If the [url removed, login to view] and [url removed, login to view] do exist the system will update the information into the associated fields.

The import file must contain [url removed, login to view] and [url removed, login to view] – all other fields are optional.

I have attached an Access database with the imported table and a spreadsheet format.

Kỹ năng: Bất kì công việc gì, Microsoft Access

Xem thêm: microsoft project import, microsoft excel spreadsheet, spreadsheet microsoft excel, emp, access d, excel access table, excel record, excel column update, selection access, access append, excel import access, excel import user interface, record excel, look table excel, information system excel project, excel database update, excel access project, excel database format, simple xls project, excel record project, import excel file project, project excel access, access information system, access database excel, simple excel project database

Về Bên Thuê:
( 0 nhận xét )

Mã Dự Án: #1911330

Đã trao cho:


Have done this sort of project several times before.

$40 USD trong 1 ngày
(0 Đánh Giá)