Welcome Guest! To enable all features please Login or Register.



Go to last post Go to first unread
#1 Posted : Sunday, October 22, 2017 2:20:37 AM(UTC)

Rank: Newbie

Groups: Registered
Joined: 10/22/2017(UTC)
Posts: 1
United States

I am trying to load a Excel xls file into the Seal Server Manager.

This file has "Call Detail Records" from a phone system.

That seems to work.

There are no errors connecting to the Excel file.

But I can't see the data.

Is there something special to load all the data?
Columns go from A to AG.
Row 1 is the name of the column
Row 2 is the first of the data
Row 43422 is the last of the data

Do I have to do something with the Definition Script?
Do I have to do something with the Load Script?

New to Seal Report.
Trying to figure things out.
#2 Posted : Monday, October 23, 2017 7:03:00 AM(UTC)

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 915

Thanks: 14 times
Was thanked: 153 time(s) in 147 post(s)
You do not need to create a No SQL DataSource to query an Excel Sheet...
I just made a quick try on \Databases\databank.worldbank.org_health_population.xlsx
Create a new Data Source
  • In the connection, use the Helper Create Connection from Excel or MS Access
  • Then you can Add Table from Catalog... it should see the Data Sheet
  • Then in your model, you can query our new elements.

Note that you need 32bit Excel Drivers on your machine
Provider=MSDASQL.1;Extended Properties="DBQ=%SEALREPOSITORY%\Databases\databank.worldbank.org_health_population.xlsx;Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};"

If you want to continue using No SQL Source (which is another option), you should put some debug messages to understand what is going wrong in your load...

Edited by user Monday, October 23, 2017 7:04:31 AM(UTC)  | Reason: Not specified

#3 Posted : Saturday, November 9, 2019 4:42:54 AM(UTC)

Rank: Newbie

Groups: Registered
Joined: 11/9/2019(UTC)
Posts: 1
United States
Location: california

Hey guys,

Few months before even I also don’t have any idea that I can create database in Excel spreadsheet. But After searching information about it, I have successfully been able to Transform My Excel Sheet As Database. So, now I can tell you how to create database in Excel simply and easily. For the complete steps you must check out this helpful post link, which is specifically written on: how to searchable create database in Excel.
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.