Support forum

sp_Search Search
Advanced Search
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

sp_Search Search
Go to Bottom
sp_TopicIcon
Excel sample
sp_NewPost Add Reply sp_NewTopic Add Topic
October 4, 2013
12:04 am
Mike Bonyad
Guest
Guests
Go to Top
3sp_EditHistory sp_Permalink sp_Print sp_QuotePost Quote

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

October 2, 2013
11:19 am
Henk Helmantel
Admin
Forum Posts: 1510
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
2sp_Permalink sp_Print sp_QuotePost Quote

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
Guest
Guests
Go to Top
1sp_Permalink sp_Print sp_QuotePost Quote

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.

Thanks,
Mike

sp_NewPost Add Reply sp_NewTopic Add Topic
Go to top
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: 680

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1155

Posts: 3945

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1510