Importing data from excel or .csv file

Open discussion about our Asset Navigator application

Importing data from excel or .csv file

Postby timkrampe on Tue Jan 30, 2007 1:27 pm

I currently have an excel spreadsheet with about 280 monitors that i want to import into the peripherals list. I am running Asset Navigator Enterprise Edition ver 4.5.3 with MS SQL 2000. I would like to be able to import the following information:

Type:
Serial Num:
Manufacturer:
Model:

The following 2 fields are optional:

Status:
User:

Can this be done?
timkrampe
Newbie
 
Posts: 1
Joined: Wed Mar 16, 2005 6:27 pm

Postby pille on Tue Mar 06, 2007 5:21 pm

In version 4.5.3 you'll find the option under Tools > Administrative > Tables Import. In version 5.2 this is under Tools > Administrative > Import Wizard.

This should allow you to import data from an Excel spreadsheet without a problem.
Contact Technical Services directly:
support@alloy-software.com
http://support.alloy-software.com

Paul Ille
Alloy Software
Maximize your IT Universe
Follow us on Twitter: http://twitter.com/alloysoftware
Image
User avatar
pille
Alloy Software
 
Posts: 473
Joined: Thu Aug 11, 2005 3:11 pm
Location: New Jersey, USA


Return to Asset Navigator 4 Discussion

Who is online

Users browsing this forum: No registered users and 2 guests

cron