Ik zou graag willen weten hoe ik het snelst een .xls bestand in de database(phpmyadmin) kan opslaan.
Het xls bestand zelf:
dltrade(.)info/Filmlijst.xls
Iemand een idee?
-
26-01-2010, 17:34 #1
Particulier
- Berichten
- 214
- Lid sinds
- 17 Jaar
xls naar database
-
In de schijnwerper
-
26-01-2010, 17:44 #2
Maas Online Media
- Berichten
- 1.019
- Lid sinds
- 17 Jaar
Gebruik de concatenate functie van Excel eb maak aparte insert statements van elke afzonderlijk record/rij en plak deze inserts in een mySQL query window in mysqladmin.
Dus iets van (check wel ff de mysql code)
Code:=TEKST.SAMENVOEGEN("Insert into Table ('";A2;"','";B2;"','";C2;"',";D2;",";E2;");")
-
26-01-2010, 18:25 #3
Particulier
- Berichten
- 21
- Lid sinds
- 15 Jaar
Opslaan in Excel als CSV en dan deze tutorial volgen :P
Succes!
-
26-01-2010, 18:59 #4
Particulier
- Berichten
- 214
- Lid sinds
- 17 Jaar
Heb de tutorial van E. Holman gebruikt maar ik krijg dit:
SQL-query:
LOAD DATA INFILE '/tmp/phptCyOHB' INTO TABLE `teun` FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n'
MySQL retourneerde:
#1045 - Access denied for user 'blabla'@'localhost' (using password: YES)
Snap niet waarom hij dit zegt :|
-
26-01-2010, 19:08 #5
Particulier
- Berichten
- 21
- Lid sinds
- 15 Jaar
Dat betekent dat je niet voldoende rechten hebt. Je hebt het recht "FILE" nodig op de MySQL server.
-
26-01-2010, 19:16 #6
Particulier
- Berichten
- 214
- Lid sinds
- 17 Jaar
dus ik moet bij mijn host zijn voordat ik iets mag uploaden :|
Origineel gepost door E. Holman
Naja alsnog bedankt voor je reactie!
-
26-01-2010, 19:26 #7
Particulier
- Berichten
- 21
- Lid sinds
- 15 Jaar
Wel in die mate.
Er zijn zat (misschien wel leukere) alternatieven :-)
CSV is zelf heel gemakkelijk te verwerken in een query m.b.v. PHP of ASP. Ervaring mee? Anders wil ik je wel helpen.
-
26-01-2010, 20:38 #8
Particulier
- Berichten
- 257
- Lid sinds
- 15 Jaar
Code:-- -------------------------------------------------------- -- -- Table structure for table `films` -- CREATE TABLE `films` ( `id` smallint(6) NOT NULL, `title` varchar(200) NOT NULL, `genre` varchar(200) NOT NULL, `url` varchar(200) NOT NULL, `imdb_rating` decimal(2,1) NOT NULL, `imdb_top250` tinyint(4) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `films` -- INSERT INTO `films` VALUES(1, '300', 'Action | Fantasy | War', 'http://imdb.com/title/tt0416449/ ', 7.8, 0); INSERT INTO `films` VALUES(2, '10.000 BC', 'Adventure | Fantasy | Romance', 'http://imdb.com/title/tt0443649/', 4.9, 0); INSERT INTO `films` VALUES(3, '12 Angry Men', 'Crime | Drama | Mystery', 'http://imdb.com/title/tt0050083/', 8.9, 8); INSERT INTO `films` VALUES(4, '2 Fast 2 Furious', 'Action | Crime | Thriller', 'http://imdb.com/title/tt0322259/', 5.1, 0); INSERT INTO `films` VALUES(5, '2012 (R5, custom subs)', '', '', 0.0, 0); INSERT INTO `films` VALUES(6, '51st State, The', 'Action | Comedy | Crime', 'http://imdb.com/title/tt0227984/', 6.1, 0); INSERT INTO `films` VALUES(7, '8 Mile', 'Drama | Music', 'http://imdb.com/title/tt0298203/', 6.7, 0); INSERT INTO `films` VALUES(8, 'A Clockwork Orange', 'Crime | Drama | Thriller', 'http://imdb.com/title/tt0066921/', 8.5, 47); INSERT INTO `films` VALUES(9, 'A Few Good Men', 'Crime | Drama | Mystery | Thriller', 'http://imdb.com/title/tt0104257/', 7.6, 0); INSERT INTO `films` VALUES(10, 'A History of Violence', 'Action | Crime | Drama | Thriller', 'http://imdb.com/title/tt0399146/', 7.6, 0); INSERT INTO `films` VALUES(11, 'Ace Ventura: Pet Detective', 'Comedy', 'http://imdb.com/title/tt0109040/', 6.6, 0); INSERT INTO `films` VALUES(12, 'Ace Ventura: When Nature Calls', 'Comedy', 'http://imdb.com/title/tt0112281/', 5.5, 0); INSERT INTO `films` VALUES(13, 'Air I Breathe, The', 'Crime | Drama | Romance | Thriller', 'http://imdb.com/title/tt0485851/', 7.1, 0); INSERT INTO `films` VALUES(14, 'Ali', 'Biography | Drama | Sport', 'http://imdb.com/title/tt0248667/', 6.6, 0); INSERT INTO `films` VALUES(15, 'Ali G In Da House', 'Comedy', 'http://imdb.com/title/tt0284837/', 6.0, 0); INSERT INTO `films` VALUES(16, 'American Beauty', 'Drama', 'http://imdb.com/title/tt0169547/', 8.6, 36); INSERT INTO `films` VALUES(17, 'American Gangster', 'Crime | Drama', 'http://imdb.com/title/tt0765429/', 8.0, 0); INSERT INTO `films` VALUES(18, 'American History X', 'Crime | Drama', 'http://imdb.com/title/tt0120586/', 8.6, 37); INSERT INTO `films` VALUES(19, 'American Pie: Beta House', 'Comedy', 'http://imdb.com/title/tt0974959/', 5.6, 0); INSERT INTO `films` VALUES(20, 'American Psycho', 'Crime | Drama | Horror | Thriller', 'http://imdb.com/title/tt0144084/', 7.4, 0); INSERT INTO `films` VALUES(21, 'Anchorman: The Legend of Ron Burgundy', 'Comedy | Romance', 'http://imdb.com/title/tt0357413/', 7.0, 0); INSERT INTO `films` VALUES(22, 'Angels & Demons', 'Mystery | Thriller', 'http://imdb.com/title/tt0808151/', 6.7, 0); INSERT INTO `films` VALUES(23, 'Apocalypto', 'Action | Adventure | Drama', 'http://imdb.com/title/tt0472043/', 7.9, 0); INSERT INTO `films` VALUES(24, 'As Good As It Gets', 'Comedy | Drama | Romance', 'http://imdb.com/title/tt0119822/', 7.8, 0); INSERT INTO `films` VALUES(25, 'Bandits', 'Comedy | Crime | Drama | Romance', 'http://imdb.com/title/tt0219965/', 6.6, 0); INSERT INTO `films` VALUES(26, 'Banlieue 13', 'Action | Crime | Sci-Fi', 'http://imdb.com/title/tt0414852/', 7.1, 0); INSERT INTO `films` VALUES(27, 'Batman Begins', 'Action | Crime | Thriller', 'http://imdb.com/title/tt0372784/', 8.3, 102); INSERT INTO `films` VALUES(28, 'Being John Malkovich', 'Comedy | Fantasy', 'http://imdb.com/title/tt0120601/', 7.9, 0); INSERT INTO `films` VALUES(29, 'Big Lebowski, The', 'Comedy | Crime', 'http://imdb.com/title/tt0118715/', 8.2, 127); INSERT INTO `films` VALUES(30, 'Black Hawk Down', 'Action | Drama | War', 'http://imdb.com/title/tt0265086/', 7.7, 0); INSERT INTO `films` VALUES(31, 'Blair Witch Project, The', 'Horror | Mystery | Thriller', 'http://imdb.com/title/tt0185937/', 6.2, 0); INSERT INTO `films` VALUES(32, 'Blood Diamond', 'Action | Adventure | Drama | Thriller', 'http://imdb.com/title/tt0450259/', 8.0, 127); INSERT INTO `films` VALUES(33, 'Body of Lies', 'Action | Drama | Thriller', 'http://imdb.com/title/tt0758774/', 7.2, 0); INSERT INTO `films` VALUES(34, 'Boondock Saints, The', 'Action | Crime | Drama | Thriller', 'http://imdb.com/title/tt0144117/', 7.9, 0); INSERT INTO `films` VALUES(35, 'Bourne Identity, The', 'Action | Adventure | Mystery | Thriller', 'http://imdb.com/title/tt0258463/', 7.7, 0); INSERT INTO `films` VALUES(36, 'Bourne Supremacy, The', 'Action | Adventure | Mystery | Thriller', 'http://imdb.com/title/tt0372183/', 7.6, 0); INSERT INTO `films` VALUES(37, 'Bourne Ultimatum, The', 'Action | Adventure | Mystery | Thriller', 'http://imdb.com/title/tt0440963/', 8.2, 127); INSERT INTO `films` VALUES(38, 'Boy in the Striped Pyjama''s, The', 'Drama | Thriller | War', 'http://imdb.com/title/tt0914798/', 7.8, 0); INSERT INTO `films` VALUES(39, 'Braveheart', 'Action | Biography | Drama | War', 'http://imdb.com/title/tt0112573/', 8.4, 90); INSERT INTO `films` VALUES(40, 'Bucket List, The', 'Adventure | Comedy | Drama', 'http://imdb.com/title/tt0825232/', 7.5, 0); INSERT INTO `films` VALUES(41, 'Burn After Reading', 'Comedy | Crime | Drama', 'http://imdb.com/title/tt0887883/', 7.3, 0); INSERT INTO `films` VALUES(42, 'Casino Royale', 'Action | Adventure | Thriller', 'http://imdb.com/title/tt0381061/', 8.0, 127); INSERT INTO `films` VALUES(43, 'Chamber, The', 'Drama | Thriller', 'http://imdb.com/title/tt0115862/', 5.7, 0); INSERT INTO `films` VALUES(44, 'Children of Men', 'Adventure | Mystery | Sci-Fi | Thriller', 'http://imdb.com/title/tt0206634/', 8.1, 127); INSERT INTO `films` VALUES(45, 'Chinatown', 'Mystery | Thriller', 'http://imdb.com/title/tt0071315/', 8.5, 60); INSERT INTO `films` VALUES(46, 'Christiane F', 'Drama | Music', 'http://imdb.com/title/tt0082176/', 7.6, 0); INSERT INTO `films` VALUES(47, 'Crash', 'Crime | Drama', 'http://imdb.com/title/tt0375679/', 8.0, 127); INSERT INTO `films` VALUES(48, 'Crossroads', 'Drama | Music | Mystery | Romance', 'http://imdb.com/title/tt0090888/', 6.6, 0); INSERT INTO `films` VALUES(49, 'Da Vinci Code, The', 'Mystery | Thriller', 'http://imdb.com/title/tt0382625/', 6.4, 0); INSERT INTO `films` VALUES(50, 'Dark Knight, The', 'Action | Crime | Drama | Thriller', 'http://imdb.com/title/tt0468569/', 8.9, 9); INSERT INTO `films` VALUES(51, 'Das Experiment', 'Drama | Thriller', 'http://imdb.com/title/tt0250258/', 7.9, 0); INSERT INTO `films` VALUES(52, 'Das Leben Der Anderen', 'Drama | Thriller', 'http://imdb.com/title/tt0405094/', 8.5, 54); INSERT INTO `films` VALUES(53, 'Dead Man Walking', 'Crime | Drama', 'http://imdb.com/title/tt0112818/', 7.7, 0); INSERT INTO `films` VALUES(54, 'Death Sentence', 'Action | Drama | Thriller', 'http://imdb.com/title/tt0804461/', 6.8, 0); INSERT INTO `films` VALUES(55, 'Deep Blue Sea', 'Action | Horror | Thriller', 'http://imdb.com/title/tt0149261/', 5.6, 0); INSERT INTO `films` VALUES(56, 'Deer Hunter, The', 'Drama | War', 'http://imdb.com/title/tt0077416/', 8.2, 127); INSERT INTO `films` VALUES(57, 'Defiance', 'Action | Drama | Thriller | War', 'http://imdb.com/title/tt1034303/', 7.3, 0); INSERT INTO `films` VALUES(58, 'Der Untergang', 'Biography | Drama | History | War', 'http://imdb.com/title/tt0363163/', 8.4, 80); INSERT INTO `films` VALUES(59, 'Die Hard', 'Action | Crime | Drama | Thriller', 'http://imdb.com/title/tt0095016/', 8.3, 114); INSERT INTO `films` VALUES(60, 'Die Hard 2', 'Action | Crime | Drama | Thriller', 'http://imdb.com/title/tt0099423/', 7.0, 0); INSERT INTO `films` VALUES(61, 'Die Hard 4.0', 'Action | Crime | Drama | Thriller', 'http://imdb.com/title/tt0337978/', 7.5, 0); INSERT INTO `films` VALUES(62, 'Die Hard with a Vengeance', 'Action | Crime | Drama | Thriller', 'http://imdb.com/title/tt0112864/', 7.4, 0); INSERT INTO `films` VALUES(63, 'Donnie Brasco', 'Crime | Drama | Thriller', 'http://imdb.com/title/tt0119008/', 7.7, 0); INSERT INTO `films` VALUES(64, 'Don''t Be A Menace', 'Comedy', 'http://imdb.com/title/tt0116126/', 6.1, 0); INSERT INTO `films` VALUES(65, 'Eastern Promises', 'Crime | Drama | Mystery | Thriller', 'http://imdb.com/title/tt0765443/', 7.8, 0); INSERT INTO `films` VALUES(66, 'Elephant Man, The', 'Biography | Drama | History', 'http://imdb.com/title/tt0080678/', 8.4, 91); INSERT INTO `films` VALUES(67, 'Enemies of Reason, The', 'Documentary', 'http://imdb.com/title/tt1092058/', 8.5, 0); INSERT INTO `films` VALUES(68, 'Enemy at the Gates', 'Drama | History | Thriller | War', 'http://imdb.com/title/tt0215750/', 7.4, 0); INSERT INTO `films` VALUES(69, 'Enemy of the State', 'Action | Drama | Thriller', 'http://imdb.com/title/tt0120660/', 7.2, 0); INSERT INTO `films` VALUES(70, 'Eternal Sunshine of the Spotless Mind', 'Drama | Romance', 'http://imdb.com/title/tt0338013/', 8.5, 58); INSERT INTO `films` VALUES(71, 'Fargo', 'Crime | Thriller', 'http://imdb.com/title/tt0116282/', 8.3, 117); INSERT INTO `films` VALUES(72, 'Fast and the Furious, The', 'Action | Crime | Thriller', 'http://imdb.com/title/tt0232500/', 5.9, 0); INSERT INTO `films` VALUES(73, 'Fight Club', 'Drama | Mystery | Thriller', 'http://imdb.com/title/tt0137523/', 8.8, 18); INSERT INTO `films` VALUES(74, 'Five Minutes of Heaven', 'Crime | Drama | Thriller', 'http://imdb.com/title/tt1238291/', 7.0, 0); INSERT INTO `films` VALUES(75, 'Flags of our Fathers', 'Action | Drama | History | War', 'http://imdb.com/title/tt0418689/', 7.2, 0); INSERT INTO `films` VALUES(76, 'Forrest Gump', 'Comedy | Drama | Romance | War', 'http://imdb.com/title/tt0109830/', 8.6, 38); INSERT INTO `films` VALUES(77, 'Four Brothers', 'Action | Crime | Drama | Mystery | Thriller', 'http://imdb.com/title/tt0430105/', 6.9, 0); INSERT INTO `films` VALUES(78, 'Fracture', 'Crime | Drama | Mystery | Thriller', 'http://imdb.com/title/tt0488120/', 7.1, 0); INSERT INTO `films` VALUES(79, 'Freddy Got Fingered', 'Comedy', 'http://imdb.com/title/tt0240515/', 3.9, 0); INSERT INTO `films` VALUES(80, 'Free Willy', 'Family | Adventure | Drama', 'http://imdb.com/title/tt0106965/', 5.4, 0); INSERT INTO `films` VALUES(81, 'Free Willy 2', 'Family | Adventure | Drama', 'http://imdb.com/title/tt0113114/', 4.3, 0); INSERT INTO `films` VALUES(82, 'Full Metal Jacket', 'Action | Drama | War', 'http://imdb.com/title/tt0093058/', 8.4, 87); INSERT INTO `films` VALUES(83, 'Game, The', 'Action | Adventure | Mystery | Thriller', 'http://imdb.com/title/tt0119174/', 7.7, 0); INSERT INTO `films` VALUES(84, 'Gamer', 'Action | Sci-Fi | Thriller', 'http://imdb.com/title/tt1034032/', 5.9, 0); INSERT INTO `films` VALUES(85, 'Gladiator', 'Action | Adventure | Drama | History', 'http://imdb.com/title/tt0172495/', 8.3, 105); INSERT INTO `films` VALUES(86, 'Godfather, The', 'Crime | Drama | Thriller', 'http://imdb.com/title/tt0068646/', 9.2, 2); INSERT INTO `films` VALUES(87, 'Godfather: Part II, The', 'Crime | Drama | Thriller', 'http://imdb.com/title/tt0071562/', 9.0, 3); INSERT INTO `films` VALUES(88, 'Godfather: Part III, The', 'Crime | Drama | Thriller', 'http://imdb.com/title/tt0099674/', 7.6, 0); INSERT INTO `films` VALUES(89, 'Good Will Hunting', 'Drama', 'http://imdb.com/title/tt0119217/', 8.0, 127); INSERT INTO `films` VALUES(90, 'GoodFellas', 'Biography | Crime | Drama', 'http://imdb.com/title/tt0099685/', 8.8, 14); INSERT INTO `films` VALUES(91, 'Gran Torino', 'Crime | Drama', 'http://imdb.com/title/tt1205489/', 8.4, 82); INSERT INTO `films` VALUES(92, 'Hannibal', 'Crime | Thriller', 'http://imdb.com/title/tt0212985/', 6.4, 0); INSERT INTO `films` VALUES(93, 'Happy Gilmore', 'Comedy | Romance | Sport', 'http://imdb.com/title/tt0116483/', 6.9, 0); INSERT INTO `films` VALUES(94, 'Hard Boiled', 'Action | Crime | Drama | Thriller', 'http://imdb.com/title/tt0104684/', 7.9, 0); INSERT INTO `films` VALUES(95, 'Harold & Kumar escape from Guantanamo Bay', 'Adventure | Comedy', 'http://imdb.com/title/tt0481536/', 6.8, 0); INSERT INTO `films` VALUES(96, 'Harold & Kumar go to White Castle', 'Adventure | Comedy', 'http://imdb.com/title/tt0366551/', 7.2, 0); INSERT INTO `films` VALUES(97, 'Haunting in Connecticut, The', 'Drama | Horror | Thriller', 'http://imdb.com/title/tt0492044/', 5.8, 0); INSERT INTO `films` VALUES(98, 'Heat', 'Action | Crime | Drama | Thriller', 'http://imdb.com/title/tt0113277/', 8.3, 123); INSERT INTO `films` VALUES(99, 'Hills Have Eyes, The', 'Horror | Thriller', 'http://imdb.com/title/tt0454841/', 6.5, 0); INSERT INTO `films` VALUES(100, 'Hotel Rwanda', 'Drama | History | Thriller | War', 'http://imdb.com/title/tt0395169/', 8.3, 108); INSERT INTO `films` VALUES(101, 'I Am Legend', 'Drama | Horror | Sci-Fi | Thriller', 'http://imdb.com/title/tt0480249/', 7.1, 0); INSERT INTO `films` VALUES(102, 'Into the Wild', 'Adventure | Biography | Drama', 'http://imdb.com/title/tt0758758/', 8.2, 127); INSERT INTO `films` VALUES(103, 'Islam: What the west needs to know', 'Documentary', 'http://imdb.com/title/tt0818682/', 6.1, 0); INSERT INTO `films` VALUES(104, 'Island, The', 'Action | Sci-Fi | Thriller', 'http://imdb.com/title/tt0399201/', 6.9, 0); INSERT INTO `films` VALUES(105, 'Jeff Dunham Spark of Insanity', 'Comedy', 'http://imdb.com/title/tt1143143/', 8.4, 0); INSERT INTO `films` VALUES(106, 'Kill Bill: Vol 1', 'Action | Thriller', 'http://imdb.com/title/tt0266697/', 8.2, 127); INSERT INTO `films` VALUES(107, 'Kill Bill: Vol 2', 'Action | Thriller', 'http://imdb.com/title/tt0378194/', 8.0, 127); INSERT INTO `films` VALUES(108, 'Kingdom of Heaven', 'Action | Adventure | History', 'http://imdb.com/title/tt0320661/', 7.1, 0); INSERT INTO `films` VALUES(109, 'LA Confidential', 'Crime | Drama | Mystery | Thriller', 'http://imdb.com/title/tt0119488/', 8.4, 63); INSERT INTO `films` VALUES(110, 'Land of the Lost', 'Adventure | Comedy | Sci-Fi', 'http://imdb.com/title/tt0457400/', 5.4, 0); INSERT INTO `films` VALUES(111, 'Last King of Scotland, The', 'Biography | Drama | History | Thriller', 'http://imdb.com/title/tt0455590/', 7.8, 0); INSERT INTO `films` VALUES(112, 'Leon the Professional', 'Crime | Drama | Thriller', 'http://imdb.com/title/tt0110413/', 8.6, 34); INSERT INTO `films` VALUES(113, 'Letters from Iwo Jima', 'Drama | History | War', 'http://imdb.com/title/tt0498380/', 8.1, 127); INSERT INTO `films` VALUES(114, 'Liberty Stands Still', 'Thriller | Drama', 'http://imdb.com/title/tt0280870/', 5.7, 0); INSERT INTO `films` VALUES(115, 'Lock, Stock and Two Smoking Barrels', 'Comedy | Crime | Thriller', 'http://imdb.com/title/tt0120735/', 8.1, 127); INSERT INTO `films` VALUES(116, 'Lord of the Rings: The Fellowship of the Ring', 'Action | Adventure | Fantasy', 'http://imdb.com/title/tt0120737/', 8.7, 20); INSERT INTO `films` VALUES(117, 'Lord of the Rings: The Return of the King', 'Action | Adventure | Fantasy', 'http://imdb.com/title/tt0167260/', 8.8, 11); INSERT INTO `films` VALUES(118, 'Lord of the Rings: The Two Towers', 'Action | Adventure | Fantasy', 'http://imdb.com/title/tt0167261/', 8.6, 29); INSERT INTO `films` VALUES(119, 'Lord of War', 'Crime | Drama | Thriller', 'http://imdb.com/title/tt0399295/', 7.7, 0); INSERT INTO `films` VALUES(120, 'Lovely Bones, The', 'Drama | Fantasy | Thriller', 'http://imdb.com/title/tt0380510/', 6.9, 0); INSERT INTO `films` VALUES(121, 'Lucky Number Slevin', 'Crime | Thriller', 'http://imdb.com/title/tt0425210/', 7.8, 0); INSERT INTO `films` VALUES(122, 'Magnolia', 'Drama', 'http://imdb.com/title/tt0175880/', 8.0, 127); INSERT INTO `films` VALUES(123, 'Matrix, The', 'Action | Adventure | Sci-Fi | Thriller', 'http://imdb.com/title/tt0133093/', 8.7, 25); INSERT INTO `films` VALUES(124, 'Matrix: Reloaded, The', 'Action | Adventure | Sci-Fi | Thriller', 'http://imdb.com/title/tt0234215/', 7.0, 0); INSERT INTO `films` VALUES(125, 'Matrix: Revolutions, The', 'Action | Adventure | Sci-Fi | Thriller', 'http://imdb.com/title/tt0242653/', 6.5, 0); INSERT INTO `films` VALUES(126, 'Me, Myself and Irene', 'Comedy', 'http://imdb.com/title/tt0183505/', 6.3, 0); INSERT INTO `films` VALUES(127, 'Memento', 'Mystery | Thriller', 'http://imdb.com/title/tt0209144/', 8.6, 26); INSERT INTO `films` VALUES(128, 'Men Who Stare at Goats, The', 'Comedy | War', 'http://imdb.com/title/tt1234548/', 6.7, 0); INSERT INTO `films` VALUES(129, 'Mercury Rising', 'Action | Drama | Thriller', 'http://imdb.com/title/tt0120749/', 5.8, 0); INSERT INTO `films` VALUES(130, 'Million Dollar Baby', 'Drama | Sport', 'http://imdb.com/title/tt0405159/', 8.2, 127); INSERT INTO `films` VALUES(131, 'Mongol: The Rise of Genghis Khan', 'Biography | Drama | Romance | War', 'http://imdb.com/title/tt0416044/', 7.4, 0); INSERT INTO `films` VALUES(132, 'Mystic River', 'Crime | Drama | Mystery | Thriller', 'http://imdb.com/title/tt0327056/', 8.0, 127); INSERT INTO `films` VALUES(133, 'Natural Born Killers', 'Action | Crime | Drama | Romance | Thriller', 'http://imdb.com/title/tt0110632/', 7.0, 0); INSERT INTO `films` VALUES(134, 'Old School', 'Comedy', 'http://imdb.com/title/tt0302886/', 7.0, 0); INSERT INTO `films` VALUES(135, 'One Flew Over the Cuckoo''s Nest', 'Drama', 'http://imdb.com/title/tt0073486/', 8.9, 7); INSERT INTO `films` VALUES(136, 'Orphan', 'Drama | Horror | Thriller', 'http://imdb.com/title/tt1148204/', 7.2, 0); INSERT INTO `films` VALUES(137, 'Paranormal Activity', 'Horror | Thriller', 'http://imdb.com/title/tt1179904/', 7.1, 0); INSERT INTO `films` VALUES(138, 'Pay it Forward', 'Drama | Romance', 'http://imdb.com/title/tt0223897/', 6.8, 0); INSERT INTO `films` VALUES(139, 'Pelican Brief, The', 'Crime | Drama | Mystery | Romance | Thriller', 'http://imdb.com/title/tt0107798/', 6.4, 0); INSERT INTO `films` VALUES(140, 'People Versus Larry Flynt, The', 'Biography | Drama', 'http://imdb.com/title/tt0117318/', 7.2, 0); INSERT INTO `films` VALUES(141, 'Pi', 'Drama | Sci-Fi | Thriller', 'http://imdb.com/title/tt0138704/', 7.6, 0); INSERT INTO `films` VALUES(142, 'Prestige, The', 'Drama | Mystery | Sci-Fi | Thriller', 'http://imdb.com/title/tt0482571/', 8.4, 73); INSERT INTO `films` VALUES(143, 'Pride and Glory', 'Crime | Drama | Thriller', 'http://imdb.com/title/tt0482572/', 6.7, 0); INSERT INTO `films` VALUES(144, 'Primal Fear', 'Crime | Drama | Mystery | Thriller', 'http://imdb.com/title/tt0117381/', 7.6, 0); INSERT INTO `films` VALUES(145, 'Psycho', 'Horror | Thriller', 'http://imdb.com/title/tt0054215/', 8.7, 22); INSERT INTO `films` VALUES(146, 'Public Enemies', 'Biography | Crime | Drama | History | Thriller', 'http://imdb.com/title/tt1152836/', 7.3, 0); INSERT INTO `films` VALUES(147, 'Pulp Fiction', 'Crime | Thriller', 'http://imdb.com/title/tt0110912/', 8.9, 5); INSERT INTO `films` VALUES(148, 'Rain Man', 'Drama', 'http://imdb.com/title/tt0095953/', 8.0, 0); INSERT INTO `films` VALUES(149, 'Ratatouille', 'Animation | Comedy | Family | Fantasy', 'http://imdb.com/title/tt0382932/', 8.2, 127); INSERT INTO `films` VALUES(150, 'Red Dragon', 'Crime | Thriller', 'http://imdb.com/title/tt0289765/', 7.3, 0); INSERT INTO `films` VALUES(151, 'Rendition', 'Drama | Thriller', 'http://imdb.com/title/tt0804522/', 6.9, 0); INSERT INTO `films` VALUES(152, 'Requiem for a Dream', 'Drama', 'http://imdb.com/title/tt0180093/', 8.5, 61); INSERT INTO `films` VALUES(153, 'Reservoir Dogs', 'Crime | Drama | Mystery | Thriller', 'http://imdb.com/title/tt0105236/', 8.4, 64); INSERT INTO `films` VALUES(154, 'RocknRolla', 'Action | Comedy | Crime', 'http://imdb.com/title/tt1032755/', 7.3, 0); INSERT INTO `films` VALUES(155, 'Rounders', 'Drama', 'http://imdb.com/title/tt0128442/', 7.3, 0); INSERT INTO `films` VALUES(156, 'Rules of Engagement', 'Action | Drama | Thriller | War', 'http://imdb.com/title/tt0160797/', 6.2, 0); INSERT INTO `films` VALUES(157, 'Runaway Jury', 'Drama | Thriller', 'http://imdb.com/title/tt0313542/', 7.1, 0); INSERT INTO `films` VALUES(158, 'Saving Private Ryan', 'Action | Drama | War', 'http://imdb.com/title/tt0120815/', 8.5, 46); INSERT INTO `films` VALUES(159, 'Saw', 'Horror | Mystery | Thriller', 'http://imdb.com/title/tt0387564/', 7.7, 0); INSERT INTO `films` VALUES(160, 'Saw II', 'Horror | Mystery | Thriller', 'http://imdb.com/title/tt0432348/', 6.8, 0); INSERT INTO `films` VALUES(161, 'Saw III', 'Horror | Mystery | Thriller', 'http://imdb.com/title/tt0489270/', 6.3, 0); INSERT INTO `films` VALUES(162, 'Saw IV', 'Horror | Mystery | Thriller', 'http://imdb.com/title/tt0890870/', 6.0, 0); INSERT INTO `films` VALUES(163, 'Saw V', 'Horror | Mystery | Thriller', 'http://imdb.com/title/tt1132626/', 5.8, 0); INSERT INTO `films` VALUES(164, 'Saw VI (R5, custom subs)', '', '', 0.0, 0); INSERT INTO `films` VALUES(165, 'Scarface', 'Crime | Drama | Thriller', 'http://imdb.com/title/tt0086250/', 8.2, 127); INSERT INTO `films` VALUES(166, 'Schindler''s List', 'Biography | Drama | History | War', 'http://imdb.com/title/tt0108052/', 8.9, 6); INSERT INTO `films` VALUES(167, 'Score, The', 'Action | Crime | Drama | Thriller', 'http://imdb.com/title/tt0227445/', 6.8, 0); INSERT INTO `films` VALUES(168, 'Se7en', 'Crime | Drama | Mystery | Thriller', 'http://imdb.com/title/tt0114369/', 8.6, 27); INSERT INTO `films` VALUES(169, 'Shawshank Redemption, The', 'Crime | Drama', 'http://imdb.com/title/tt0111161/', 9.2, 1); INSERT INTO `films` VALUES(170, 'Shining, The', 'Horror | Thriller', 'http://imdb.com/title/tt0081505/', 8.5, 48); INSERT INTO `films` VALUES(171, 'Shooter', 'Action | Crime | Mystery | Thriller', 'http://imdb.com/title/tt0822854/', 7.2, 0); INSERT INTO `films` VALUES(172, 'Silence of the Lambs, The', 'Crime | Thriller', 'http://imdb.com/title/tt0102926/', 8.7, 24); INSERT INTO `films` VALUES(173, 'Sin City', 'Action | Crime | Thriller', 'http://imdb.com/title/tt0401792/', 8.4, 92); INSERT INTO `films` VALUES(174, 'Sixth Sense, The', 'Drama | Mystery | Thriller', 'http://imdb.com/title/tt0167404/', 8.2, 127); INSERT INTO `films` VALUES(175, 'Snatch', 'Comedy | Crime | Thriller', 'http://imdb.com/title/tt0208092/', 8.2, 127); INSERT INTO `films` VALUES(176, 'Sophie Scholl', 'Biography | Crime | Drama | History | War', 'http://imdb.com/title/tt0426578/', 7.9, 0); INSERT INTO `films` VALUES(177, 'State of Play', 'Drama | Mystery | Thriller', 'http://imdb.com/title/tt0473705/', 7.4, 0); INSERT INTO `films` VALUES(178, 'Street Kings', 'Action | Crime | Drama | Thriller', 'http://imdb.com/title/tt0421073/', 7.0, 0); INSERT INTO `films` VALUES(179, 'Superbad', 'Comedy', 'http://imdb.com/title/tt0829482/', 7.8, 0); INSERT INTO `films` VALUES(180, 'Swordfish', 'Action | Thriller | Crime', 'http://imdb.com/title/tt0244244/', 6.3, 0); INSERT INTO `films` VALUES(181, 'Syriana', 'Drama | Thriller', 'http://imdb.com/title/tt0365737/', 7.1, 0); INSERT INTO `films` VALUES(182, 'Taken', 'Action | Crime | Drama | Thriller', 'http://imdb.com/title/tt0936501/', 7.9, 0); INSERT INTO `films` VALUES(183, 'Taking of Pelham 1, 2, 3, The', 'Crime | Thriller', 'http://imdb.com/title/tt1111422/', 6.5, 0); INSERT INTO `films` VALUES(184, 'Team America: World Police', 'Action | Adventure | Comedy', 'http://imdb.com/title/tt0372588/', 7.1, 0); INSERT INTO `films` VALUES(185, 'There Will Be Blood ', 'Drama | Thriller', 'http://imdb.com/title/tt0469494/', 8.2, 127); INSERT INTO `films` VALUES(186, 'Training Day', 'Crime | Drama | Thriller', 'http://imdb.com/title/tt0139654/', 7.6, 0); INSERT INTO `films` VALUES(187, 'Trainspotting', 'Comedy | Crime | Drama', 'http://imdb.com/title/tt0117951/', 8.2, 127); INSERT INTO `films` VALUES(188, 'Traitor', 'Crime | Drama | Thriller', 'http://imdb.com/title/tt0988047/', 7.1, 0); INSERT INTO `films` VALUES(189, 'Transformers: Revenge of the Fallen', 'Action | Adventure | Sci-Fi', 'http://imdb.com/title/tt1055369/', 6.1, 0); INSERT INTO `films` VALUES(190, 'True Romance', 'Crime | Romance | Thriller', 'http://imdb.com/title/tt0108399/', 7.9, 0); INSERT INTO `films` VALUES(191, 'Twelve Monkeys', 'Mystery | Sci-Fi | Thriller', 'http://imdb.com/title/tt0114746/', 8.1, 127); INSERT INTO `films` VALUES(192, 'Ugly Truth, The', 'Comedy | Romance', 'http://imdb.com/title/tt1142988/', 6.5, 0); INSERT INTO `films` VALUES(193, 'Underworld', 'Action | Fantasy | Sci-Fi | Thriller', 'http://imdb.com/title/tt0320691/', 6.7, 0); INSERT INTO `films` VALUES(194, 'Underworld Evolution', 'Action | Fantasy | Sci-Fi | Thriller', 'http://imdb.com/title/tt0401855/', 6.6, 0); INSERT INTO `films` VALUES(195, 'Underworld Rise of the Lycans', 'Action | Fantasy | Sci-Fi | Thriller', 'http://imdb.com/title/tt0834001/', 6.5, 0); INSERT INTO `films` VALUES(196, 'Usual Suspects, The', 'Crime | Mystery | Thriller', 'http://imdb.com/title/tt0114814/', 8.7, 21); INSERT INTO `films` VALUES(197, 'V for Vendetta', 'Action | Sci-Fi | Thriller', 'http://imdb.com/title/tt0434409/', 8.2, 127); INSERT INTO `films` VALUES(198, 'Vantage Point', 'Action | Crime | Drama | Thriller', 'http://imdb.com/title/tt0443274/', 6.7, 0); INSERT INTO `films` VALUES(199, 'Walking with Dinosaurs', 'Documentary | Animation | History', 'http://imdb.com/title/tt0214382/', 8.9, 0); INSERT INTO `films` VALUES(200, 'Wanted', 'Action | Crime | Thriller', 'http://imdb.com/title/tt0493464/', 6.9, 0); INSERT INTO `films` VALUES(201, 'Wedding Crashers', 'Comedy | Romance', 'http://imdb.com/title/tt0396269/', 7.2, 0); INSERT INTO `films` VALUES(202, 'Woodsman, The', 'Drama', 'http://imdb.com/title/tt0361127/', 7.4, 0); INSERT INTO `films` VALUES(203, 'Worlds Greatest Dad', 'Comedy | Drama', 'http://imdb.com/title/tt1262981/', 7.3, 0); INSERT INTO `films` VALUES(204, 'Wrestler, The', 'Drama | Sport', 'http://imdb.com/title/tt1125849/', 8.2, 126); INSERT INTO `films` VALUES(205, 'Zack and Miri Make a Porno', 'Comedy | Drama | Romance', 'http://imdb.com/title/tt1007028/', 7.1, 0);
-
26-01-2010, 20:43 #9
Particulier
- Berichten
- 21
- Lid sinds
- 15 Jaar
Waar baseer je die informatie op? Mis ik iets?
Je hebt gelijk dat je op zo'n manier informatie toevoegt aan een database maar niet op z'n manier vanuit een .xls bestand...
Origineel gepost door Ruud van der Velden
-
26-01-2010, 23:07 #10
Particulier
- Berichten
- 214
- Lid sinds
- 17 Jaar
Heel erg bedankt :)
-
27-01-2010, 08:31 #11
Particulier
- Berichten
- 257
- Lid sinds
- 15 Jaar
Ik begreep uit de post dat het om een éénmalige actie ging? Nou, aangezien ik wel een csv via PHPMyAdmin kan importeren heb ik dat gedaan voor poster en een export daarvan in SQL hier gepost. Zo kan de TP eenvoudig knippen plakken. Origineel gepost door E. Holman
Als het vaker voorkomt heeft hij daar inderdaad niets aan.
-
27-01-2010, 08:59 #12
Particulier
- Berichten
- 21
- Lid sinds
- 15 Jaar
Aah oke, ik heb geen bijlage gezien namelijk, vandaar :-)
Origineel gepost door Ruud van der Velden
-
27-01-2010, 12:56 #13
Particulier
- Berichten
- 257
- Lid sinds
- 15 Jaar
Zie OP Origineel gepost door E. Holman
Het xls bestand zelf:
dltrade(.)info/Filmlijst.xls
-
27-01-2010, 17:43 #14
Particulier
- Berichten
- 214
- Lid sinds
- 17 Jaar
Hier bedank ik je ook voor :)
Is op dit moment niet meer nodig maar ga wel mijn host hierom vragen :)
-
27-01-2010, 18:20 #15
Reinschaap Punt NL
- Berichten
- 935
- Lid sinds
- 17 Jaar
ik gebruik navicat voor de database benadering en daar zit een uitstekende import functionaliteit in
