Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

Excel sample
sp_NewPost Add Reply sp_NewTopic Add Topic
October 4, 2013
12:04 am
Mike Bonyad

Henk, I am just using the Excel sheet to import data into SQL express.

October 2, 2013
11:19 am
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Mike,

Using Excel as a database with the SQL Connector in Diafaan SMS Server is not a very good option, it is far better to use a real database like Microsoft Access or Microsoft SQL Server (Express). The SQL Connector is quite strict with regards to the data type of the database fields and this can be a problem with Excel and text files.

Regards, Henk

October 1, 2013
8:43 pm
Mike Bonyad

Hi Henk,
I was wondering if you could post a sample Excel sheet to clarify some issues I have. I am sorry, I am not that well versed with SQL and every time I try to load a sample file to SMS server, I get a whole lot of errors including I didn't match the character numbers with the ones required by the table.


Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
5 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 678

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1149

Posts: 3929

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1502