Anyone know of any software that can help me?

[dvlsadvct]

Was wondering if there is a program out there that can do what I need...

Basically, i'm trying to get data transferred from cells in an excel spreadsheet to another program.

So, we enter data onto spreadsheets, such as


[ X ] [ Y ] [ Z ]
[ X ] [ Y ] [ Z ]
[ X ] [ Y ] [ Z ]
[ X ] [ Y ] [ Z ]
[ X ] [ Y ] [ Z ]
[ X ] [ Y ] [ Z ]

Is there any program that can get the data in the first "X" cell and transfer it to a text field or drop-down list , then grab the data in the "Y" cell and transfer it to another text field, then grab the data in the "Z" cell and transfer it to another text field?


As it is now,

I input all the data in excel.

Then i print out the sheet.

And from there, I open up another program and manually input the data into that program while reading it off of the printed sheet.

Currently, I read the first "X" cell on the sheet then type in the data into the other program, then hit tab, then read the "Y" cell then type in the data into the other program, then hit tab, then read the "Z" cell and enter that into the other program. And i repeat that (as you can see, I'm hitting "Tab" numerous times and going back and forth between the printed sheet and the monitor)

It's not likely that I'm allowed to bypass Excel and enter the data directly to that other program.

So, basically, I'm looking to enter the data to Excel, then when done, have it automatically transferred to another program

Meaning, the program would have to grab text, transfer it, then grab more text and transfer it to the next field, and so forth


EDITED MY POST: i guess to clarify, let's not use Access. Let's just say i'm trying to transfer text from excel to another program that contains text fields and boxes and drop down lists

[Fou-Lu]

I don't know of such software and its been while since I've used excel; however, I do seem to recall that excel has a builtin data tool that allows you to export you're spreadsheets to an access database. Since databases have a logical structure similar to an excel document for our perspective, it makes sense that this would be easy to do.

Worst comes to worse, export the data as a text file and import that file into access.

[greasonwolfe]

I've never messed with Excel, but if the software packages you are using can access (import/export) comma separated files (.csv) you might want to try that. It may save you some time.

[demtron]

This may be a candidate for using Excel VBA. Depending on the interface in the target application, you can use VBA to create a CSV file or even automate the import process as well if the app has an application programming interface (API). This would eliminate the need to use an intermediate app such as Access to manipulate and generate the data you need.

[ramm19]

You could tell us what's the receiving program you are talking about... I doubt there's a production software that would do such thing.

As greasonwolfe said, and I will extend, you could export it to .csv, take it into MySQL and create a web app (PHP) that would display the data they way you want it to. Quite simple.

[bazz]

I don't know of any software designed for this and so when I needed to do the same sthing as you seem to be trying, I was transferring to MySQL:

If that is what you are actually doing, then my steps may help.

make a csv file from excel, using the save as option.
uploaded to my sql using phpMyAdmin.
wrote about 3 queries, to copy fields from one table to any other I needed it in. Then I used phpMyAdmin to delete the cols from the first table that I csv'd to.

hth

bazz

[demtron]

To the OP...

It would really help if you could tell us what the destination application is. Many of the responses here mention using technologies like PHP and MySQL. Based on your description, I don't see the need to introduce Web or database technologies to accomplish what you want. Excel VBA can handle a data transformation to CSV and very likely automate the import into your application. However, to give you the best answer, it would really help to know what the destination app is.

[effpeetee]

This from Google.

Converting an Excel Spreadsheet to an Access Database
(http://faculty.washington.edu/larsson/conf/aiha98/primer/excel-c.htm)

Frank