(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Importing data from one sheet of an excel file.
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Importing data from one sheet of an excel file. (Read 457 times)
NHUser
Full Member
***
Offline



Posts: 320
Location: Amherst, NH
Joined: Aug 2nd, 2010
Importing data from one sheet of an excel file.
Nov 28th, 2016 at 10:12pm
Print Post Print Post  
I know how to import data from an excel file, or a .csv text file.  I was wondering if there is a way to import information from one sheet in a multi-sheet excel file?
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Importing data from one sheet of an excel file.
Reply #1 - Dec 1st, 2016 at 2:23pm
Print Post Print Post  
Hey Paul,

You would have to save that one sheet's data out as a CSV file which could then be imported into Sesame. With it as the active sheet in Excel, just do a File->Save as and choose CSV. This will save only that sheet's data out to CSV.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge