[faiz1]

hi, i need ur people help . i am working on a project i am stuck on a point where i cnt get around it .i hope u people can help me .
my project requires me to update the database from a file . i dnt even have a clue where to start wht to do can u people help me ??

[June7]

What application is your project and what file type is the data in?

[faiz1]

type of data : well its numbers and names .... its for updating the all the detials of a students records from a single file in a single go !!

[JackOfAllTrades]

Databases usually have some sort of bulk copy utility, often called bcp. I'd look into that.

[faiz1]

thx buddy do look into it ..as i am a begnieer i dnt have any idea regarding it !

[June7]

By file type I meant what softwares used:
Project is Access, VB, VB.Net, SQL
Data coming from/to Access, SQL, text files, Excel
?

[faiz1]

June7, on 12 Jul, 2009 - 11:24 AM, said:

By file type I meant what softwares used:
Project is Access, VB, VB.Net, SQL
Data coming from/to Access, SQL, text files, Excel
?

ohh sorry i forgot to mention that .. i am using xampp and files are in form of excel.

[June7]

Apparently, xampp supports MySQL data files. Is the destination table SQL? Export from Excel to .txt or .csv then use MySQL command
LOAD DATA INFILE 'path/file.txt' INTO TABLE your_table
Found this in net search, not personal experience.
http://forums.mysql....hp?79,1888,2313

[faiz1]

June7, on 13 Jul, 2009 - 03:28 PM, said:

Apparently, xampp supports MySQL data files. Is the destination table SQL? Export from Excel to .txt or .csv then use MySQL command
LOAD DATA INFILE 'path/file.txt' INTO TABLE your_table
Found this in net search, not personal experience.
http://forums.mysql....hp?79,1888,2313

thanks june7. i am a begnieer so i dnt understand yet the detials of the words ur using but wht i can understand is my database is in xampp . i have to update this database from a excel sheet. now i dnt know whether database in xampp is in sql or mysql.

[kzimmerm]

faiz1, on 13 Jul, 2009 - 07:19 PM, said:

June7, on 13 Jul, 2009 - 03:28 PM, said:

Apparently, xampp supports MySQL data files. Is the destination table SQL? Export from Excel to .txt or .csv then use MySQL command
LOAD DATA INFILE 'path/file.txt' INTO TABLE your_table
Found this in net search, not personal experience.
http://forums.mysql....hp?79,1888,2313

thanks june7. i am a begnieer so i dnt understand yet the detials of the words ur using but wht i can understand is my database is in xampp . i have to update this database from a excel sheet. now i dnt know whether database in xampp is in sql or mysql.

Importing excel spreadsheets into SQL Server is a snap using the Import wizard which creates an SSIS package. That package can be save for later to import additional spreadsheets.


Kurt

[faiz1]

Quote

Importing excel spreadsheets into SQL Server is a snap using the Import wizard which creates an SSIS package. That package can be save for later to import additional spreadsheets.


Kurt

thx kurt but i am not that advance in database so i cnt understand a thing what you wrote thx any way ...i would be help full if u explian in little simple words