Click here to Skip to main content
15,566,245 members
Home / Discussions / Database
   

Database

 
AnswerRe: data base system Pin
Eddy Vluggen19-May-12 1:39
professionalEddy Vluggen19-May-12 1:39 
QuestionHow to sort result if data fields contains both numeric and character value Pin
Rupesh Kumar Swami17-May-12 22:20
Rupesh Kumar Swami17-May-12 22:20 
AnswerRe: How to sort result if data fields contains both numeric and character value Pin
Eddy Vluggen19-May-12 1:32
professionalEddy Vluggen19-May-12 1:32 
QuestionExcel, OleDb, ACE, and skipping header rows Pin
PIEBALDconsult17-May-12 11:46
professionalPIEBALDconsult17-May-12 11:46 
AnswerRe: Excel, OleDb, ACE, and skipping header rows Pin
Jörgen Andersson17-May-12 12:39
professionalJörgen Andersson17-May-12 12:39 
GeneralRe: Excel, OleDb, ACE, and skipping header rows Pin
PIEBALDconsult17-May-12 15:20
professionalPIEBALDconsult17-May-12 15:20 
GeneralRe: Excel, OleDb, ACE, and skipping header rows Pin
Jörgen Andersson17-May-12 21:36
professionalJörgen Andersson17-May-12 21:36 
GeneralRe: Excel, OleDb, ACE, and skipping header rows Pin
PIEBALDconsult21-May-12 9:38
professionalPIEBALDconsult21-May-12 9:38 
OK, I'm just looking at this again, mainly for future reference (though I'll likely forget).

Thank you, yes, that works as described -- or very nearly. The problem is that the name of the sheet contains a SPACE and therefore has to be within apostrophes e.g. ['sheet 1$'] and I have been unable to get that to work with a range.

System.Data.OleDb.OleDbException (0x80040E37): The Microsoft Access database engine could not find the object ''Report 1$B5:AE5737''.
System.Data.OleDb.OleDbException (0x80040E37): The Microsoft Access database engine could not find the object ''Report 1$'B5:AE5737'.

Just for testing I renamed the sheet to remove the SPACE and it works. Thumbs Up | :thumbsup:

Do you have a work around for this?
GeneralRe: Excel, OleDb, ACE, and skipping header rows Pin
Jörgen Andersson21-May-12 10:59
professionalJörgen Andersson21-May-12 10:59 
QuestionSerial number in SQL Pin
draghu17-May-12 1:17
draghu17-May-12 1:17 
AnswerRe: Serial number in SQL Pin
Pablo Aliskevicius17-May-12 3:48
Pablo Aliskevicius17-May-12 3:48 
AnswerRe: Serial number in SQL Pin
Andy_L_J17-May-12 21:51
Andy_L_J17-May-12 21:51 
GeneralRe: Serial number in SQL Pin
draghu17-May-12 23:11
draghu17-May-12 23:11 
QuestionSybase DB access in windows 7 Pin
VenkataRamana.Gali16-May-12 18:29
VenkataRamana.Gali16-May-12 18:29 
AnswerRe: Sybase DB access in windows 7 Pin
JohnsonLuis16-May-12 22:07
JohnsonLuis16-May-12 22:07 
QuestionOne to Many Relationships - Tabular Display Pin
eddieangel16-May-12 11:36
eddieangel16-May-12 11:36 
AnswerRe: One to Many Relationships - Tabular Display Pin
Jörgen Andersson16-May-12 12:26
professionalJörgen Andersson16-May-12 12:26 
GeneralRe: One to Many Relationships - Tabular Display Pin
eddieangel16-May-12 13:53
eddieangel16-May-12 13:53 
GeneralRe: One to Many Relationships - Tabular Display Pin
Jörgen Andersson17-May-12 2:51
professionalJörgen Andersson17-May-12 2:51 
GeneralRe: One to Many Relationships - Tabular Display Pin
eddieangel17-May-12 7:43
eddieangel17-May-12 7:43 
AnswerRe: One to Many Relationships - Tabular Display Pin
Mycroft Holmes16-May-12 13:47
professionalMycroft Holmes16-May-12 13:47 
AnswerRe: One to Many Relationships - Tabular Display Pin
PIEBALDconsult16-May-12 15:11
professionalPIEBALDconsult16-May-12 15:11 
AnswerRe: One to Many Relationships - Tabular Display Pin
vvashishta16-May-12 21:15
vvashishta16-May-12 21:15 
Questionexport to text file + SQL Pin
jojoba201115-May-12 19:02
jojoba201115-May-12 19:02 
AnswerRe: export to text file + SQL Pin
vvashishta15-May-12 21:48
vvashishta15-May-12 21:48 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.