Geek Answers Handbook

What applications do you use to enter and retrieve data through ODBC?

What applications or tools do you use to enter data into your database? I am trying to improve our existing (bulky) system that uses the php web system to enter data ... item ... at ... a ... time.

My real solution is to use a spreadsheet. It works well with texts and numbers that are human readable, but not with foreign keys that are used to connect to other rows in the table.

Imagine that I want a data row to include the city in which someone lives. The column containing this id_city, which is bound to the "city" table, which has two columns: id (serial) and name (text).

I assume that I can expand the capabilities of spreadsheets to include a drop-down menu for each row of the id_city column, which will allow the user to choose which city (displaying the text of city names), but actually saving the selected city. Thus, the spreadsheet will:
(1) show a large amount of data on each screen and
(2) can be exported as a csv file and transferred to our existing scripts that manually insert rows into the database.

I played with MS Excel and Access, as well as the OpenOffice package, but did not find what gives me the functionality that I mentioned above.

Other items on my wish list:
(1) dynamically selects the name of the cities that can be selected by the user.
(2) allow the user to click data directly into the backend (not through external files / scripts). (3) If any of the columns of the data rows is changed to the backend, the user can update the data on the screen to reflect any recent changes.

Do you know how I could improve the data entry process? What tools do you use? I use PostgreSQL for the backend and have access to MS Office, OpenOffice, as well as web solutions. I would like the solution to be flexible, powerful and not require much time for development or deployment (I know, I dream ...)

, pgAdmin3 , , , , - .

+5
5

j_random_hacker, MS Access ( Access 97) ODBC.

: ( Access 2010:)

New -> Blank Database
External Data -> ODBC Database -> Link to Data Source
Machine Data Source -> New -> System Data Source -> Select Driver (Oracle, or whatever) -> Finish
Enter a new name for your DSN, the all of the connection parameters, then click OK
Select newly created DSN, hit ok.

, Access , , .. : , , . , 3000 . 20000000 , . , , , , .

+5

- , Oracle MySQL , SQL Developer.

( ) Java + SWT , DAO, Java. , , , , , .

(, , ), Perl, CSV, id . , ? .

+2

, MS Access , - . , CRUD DB, .

+2

, , :

I used Excel and SSIS to import simple data entry files into MS SQL, but it is not adequate - there are very few opportunities for data management, and SSIS is very touching, especially when working with Excel.

+1
source

MS Access does not work with some databases other than Microsoft. There is an open source equivalent called Apache OpenOffice Base that you can try.

-1
source

More articles:


All Articles