Re: [sqr-users] Asset Mgmt interface -- SQR

["Jamie Harris" <JHarris@frederick.edu>]

I have never tried this with Excel, but I know that you can set up an
ODBC data source that points to an Excel spreadsheet.

>From what I've read on Google, you need to set up a 'named range' in
the spreadsheet first.  I assume that name becomes your "table".  

Hope this helps some.  :)


-----------------------------------------------------
James Harris
Junior Systems Programmer/Analyst
Information Technology Division
Frederick Community College
-----------------------------------------------------

>>> lakef250@yahoo.com 12/2/2002 4:28:58 PM >>>
Hi, 

Does anyone have any suggestions on getting data into Asset Mgmt from
an Excel spreadsheet using SQR? 

Should I load to the staging tables (INTFC*) and run Transaction Loader
(AMIF1000) or is there a better approach? 

Any code samples available? 

Thank you. 
Yuri


---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users
BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Harris, Jamie
TEL;WORK:2668
ORG:Work;Division of Information Technology
EMAIL;WORK;PREF:JHarris@frederick.edu
N:Harris;Jamie
TITLE:Systems Analyst, PeopleSoft
ADR;DOM;WORK;PARCEL;POSTAL:;L-205
LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=QUOTED-PRINTABLE:Harris, Jamie=0A=
L-205
END:VCARD