PDA

View Full Version : Excel - Importing from web or SQL database?


DrJ
Mar 10, 2009, 03:05 PM
Ok, I know how to Import from the Web via Excel.. that is not what I am looking for. Here is what I would like to be able to do:

We have a system that we can upload a pre-formatted PDF with variables that will pull info from our system. This works great for populating customized contracts.

I would like to do the same with Excel... upload a pre-formatted Excel file so that when the rep clicks on it, it will have codes in it that will pull data from our system to populate itself.

Is this possible?

So far, the only way I can see to do something like this would be to use the Excel function that allows you to import from the web. However, this would pull a table into a blank tab in Excel... then I would have to map all the cells over to the other tabs where I want them. Doable... but more steps for the reps (which, if anyone deals with sales reps, you know that equals more errors and inaccuracies).

Any ideas?

Thanks!

mdosh01
Mar 11, 2009, 06:06 AM
It will depend on the source of the data. Is it a database or flat files of some type?

Here is some information on importing from a database:

Mac ODBC: Importing ODBC data into Excel (http://www.actualtechnologies.com/scenario_excel_report.php)

DrJ
Mar 11, 2009, 08:56 AM
Well, this would be done using only Windows machines.

It's for a business.. and one where there is no chance of getting them to switch over to Macs

mdosh01
Mar 11, 2009, 09:15 AM
Well, this would be done using only Windows machines.

It's for a business.. and one where there is no chance of getting them to switch over to Macs

Sorry, I didn't check that. Where is the data coming from? What kind of database or file? Or is it pulled from a web site.

Here is information that may be useful: http://office.microsoft.com/en-us/excel/HA010864661033.aspx

kerryxlynn
May 19, 2009, 11:52 AM
DrJizzle.. Is there a way to send a private message to you? I have a question..

JBeaucaire
May 19, 2009, 05:37 PM
Click on DrJizzle's name.