10 Replies - 975 Views - Last Post: 17 July 2009 - 03:11 AM Rate Topic: -----

#1 faiz1  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 16
  • Joined: 17-September 08

updating database from a file

Posted 11 July 2009 - 04:25 AM

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 ??
Is This A Good Question/Topic? 0
  • +

Replies To: updating database from a file

#2 June7  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 104
  • View blog
  • Posts: 904
  • Joined: 09-December 08

Re: updating database from a file

Posted 11 July 2009 - 08:50 AM

What application is your project and what file type is the data in?
Was This Post Helpful? 0
  • +
  • -

#3 faiz1  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 16
  • Joined: 17-September 08

Re: updating database from a file

Posted 11 July 2009 - 09:24 AM

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 !!
Was This Post Helpful? 0
  • +
  • -

#4 JackOfAllTrades  Icon User is offline

  • Saucy!
  • member icon

Reputation: 6035
  • View blog
  • Posts: 23,418
  • Joined: 23-August 08

Re: updating database from a file

Posted 12 July 2009 - 07:43 AM

Databases usually have some sort of bulk copy utility, often called bcp. I'd look into that.
Was This Post Helpful? 0
  • +
  • -

#5 faiz1  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 16
  • Joined: 17-September 08

Re: updating database from a file

Posted 12 July 2009 - 07:53 AM

thx buddy do look into it ..as i am a begnieer i dnt have any idea regarding it !
Was This Post Helpful? 0
  • +
  • -

#6 June7  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 104
  • View blog
  • Posts: 904
  • Joined: 09-December 08

Re: updating database from a file

Posted 12 July 2009 - 12:24 PM

By file type I meant what softwares used:
Project is Access, VB, VB.Net, SQL
Data coming from/to Access, SQL, text files, Excel
?
Was This Post Helpful? 0
  • +
  • -

#7 faiz1  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 16
  • Joined: 17-September 08

Re: updating database from a file

Posted 13 July 2009 - 02:06 AM

View PostJune7, 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.
Was This Post Helpful? 0
  • +
  • -

#8 June7  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 104
  • View blog
  • Posts: 904
  • Joined: 09-December 08

Re: updating database from a file

Posted 13 July 2009 - 04:28 PM

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
Was This Post Helpful? 0
  • +
  • -

#9 faiz1  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 16
  • Joined: 17-September 08

Re: updating database from a file

Posted 13 July 2009 - 08:19 PM

View PostJune7, 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.
Was This Post Helpful? 0
  • +
  • -

#10 kzimmerm  Icon User is offline

  • D.I.C Head

Reputation: 3
  • View blog
  • Posts: 70
  • Joined: 08-February 09

Re: updating database from a file

Posted 15 July 2009 - 11:13 AM

View Postfaiz1, on 13 Jul, 2009 - 07:19 PM, said:

View PostJune7, 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
Was This Post Helpful? 0
  • +
  • -

#11 faiz1  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 16
  • Joined: 17-September 08

Re: updating database from a file

Posted 17 July 2009 - 03:11 AM

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 :blink: thx any way ...i would be help full if u explian in little simple words
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1