Click here to Skip to main content
15,666,947 members
Home / Discussions / Database
   

Database

 
AnswerRe: change master collation Pin
Karthik. A17-Oct-10 16:59
Karthik. A17-Oct-10 16:59 
Questiondate manipulation Pin
scottichrosaviakosmos16-Oct-10 21:37
scottichrosaviakosmos16-Oct-10 21:37 
AnswerRe: date manipulation Pin
Mycroft Holmes16-Oct-10 22:19
professionalMycroft Holmes16-Oct-10 22:19 
GeneralRe: date manipulation Pin
scottichrosaviakosmos16-Oct-10 22:40
scottichrosaviakosmos16-Oct-10 22:40 
GeneralRe: date manipulation Pin
Mycroft Holmes17-Oct-10 2:02
professionalMycroft Holmes17-Oct-10 2:02 
AnswerRe: date manipulation Pin
Alegria_Lee17-Oct-10 19:01
Alegria_Lee17-Oct-10 19:01 
QuestionInsert Excel OR CSV File into MySQL OR MSSQL Database Pin
jasonmp16-Oct-10 12:17
jasonmp16-Oct-10 12:17 
AnswerRe: Insert Excel OR CSV File into MySQL OR MSSQL Database Pin
Mycroft Holmes16-Oct-10 12:37
professionalMycroft Holmes16-Oct-10 12:37 
The main problem will be that Excel is unstructured data, if all your sheets are well formed and are all EXACTLY the same the you can write a program with 3 parts:
Folder scan that identifies each xls file
importer that reads each xls into a data table (either cell by cell or using Jet)
DAL to write the data table to the database.

Expecting a "free" tool to do this is a little much.
Never underestimate the power of human stupidity
RAH

AnswerRe: Insert Excel OR CSV File into MySQL OR MSSQL Database Pin
SimulationofSai16-Oct-10 14:31
SimulationofSai16-Oct-10 14:31 
AnswerRe: Insert Excel OR CSV File into MySQL OR MSSQL Database Pin
SQLMechanic29-Oct-10 5:47
SQLMechanic29-Oct-10 5:47 
QuestionMultiple Rows to Single Rows Pin
Chris Meech15-Oct-10 8:32
Chris Meech15-Oct-10 8:32 
AnswerPivot Pin
David Mujica15-Oct-10 9:06
David Mujica15-Oct-10 9:06 
AnswerRe: Multiple Rows to Single Rows Pin
PIEBALDconsult15-Oct-10 12:44
professionalPIEBALDconsult15-Oct-10 12:44 
AnswerRe: Multiple Rows to Single Rows Pin
Alegria_Lee15-Oct-10 17:01
Alegria_Lee15-Oct-10 17:01 
GeneralRe: Multiple Rows to Single Rows Pin
Blue_Boy16-Oct-10 5:51
Blue_Boy16-Oct-10 5:51 
GeneralRe: Multiple Rows to Single Rows Pin
Chris Meech18-Oct-10 4:17
Chris Meech18-Oct-10 4:17 
GeneralRe: Multiple Rows to Single Rows Pin
Alegria_Lee18-Oct-10 4:48
Alegria_Lee18-Oct-10 4:48 
Questionsplitting one column into many Pin
rakeshs31215-Oct-10 0:42
rakeshs31215-Oct-10 0:42 
AnswerRe: splitting one column into many Pin
J4amieC15-Oct-10 1:17
J4amieC15-Oct-10 1:17 
GeneralRe: splitting one column into many Pin
rakeshs31215-Oct-10 2:23
rakeshs31215-Oct-10 2:23 
GeneralRe: splitting one column into many Pin
J4amieC15-Oct-10 2:53
J4amieC15-Oct-10 2:53 
AnswerRe: splitting one column into many Pin
PIEBALDconsult15-Oct-10 3:07
professionalPIEBALDconsult15-Oct-10 3:07 
AnswerRe: splitting one column into many Pin
Rajesh Anuhya19-Oct-10 23:57
professionalRajesh Anuhya19-Oct-10 23:57 
Questionexesute ssis package Pin
samerh14-Oct-10 3:24
samerh14-Oct-10 3:24 
AnswerRe: exesute ssis package Pin
Vimalsoft(Pty) Ltd14-Oct-10 4:53
professionalVimalsoft(Pty) Ltd14-Oct-10 4:53 

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.