Importing/Accessing CSV Data from a form
Posted: Sun Sep 11, 2016 2:44 pm
Hello,
I'm using Base to create an invoicing database for a local charity. Due to the main user's extreme technophobe tendencies, I need someway of getting the monthly data fed into the system without going anywhere near the tables section on base. I have run her through the whole select-paste-right-click process but it's a no go. She can cope with pasting data into a spreadsheet, saving it in a directory then pressing a button on a form.
I've done some googling and it looks like there may be some ways of doing this. I'm quite happy to roll my sleeves up and teach myself a new bit of software but I'd rather know the end result was feasible before I got stuck in.
Any advice gratefully received.
Thanks,
Craig
I'm using Base to create an invoicing database for a local charity. Due to the main user's extreme technophobe tendencies, I need someway of getting the monthly data fed into the system without going anywhere near the tables section on base. I have run her through the whole select-paste-right-click process but it's a no go. She can cope with pasting data into a spreadsheet, saving it in a directory then pressing a button on a form.
I've done some googling and it looks like there may be some ways of doing this. I'm quite happy to roll my sleeves up and teach myself a new bit of software but I'd rather know the end result was feasible before I got stuck in.
Any advice gratefully received.
Thanks,
Craig