Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
CommandLine to unzip files
Hi Tony, Tried that! that doesnt work too. So now i have solved the problem by mapping the winzip directory in my Path, under control panel, systems,advanced, path. -
CommandLine to unzip files
Hi Guys, Am having a wiered problem. I have created a batchfile to unzip a csv file. the contecnt of the batch file are Winzip32.exe -min -e -o G:/LucentSiteRpt.csv.gz G:/ am not able to run this batch file from any other location but from C:/Program files/winzip. Who so? -
Date issues with importing CSV files to Mssql 2000
Hi Guys, I am importing a csv file to an ms sql server2000 DB. The format of the dates in my csv file is something like 22/01/2004. But when i import it to sql 2000 in a Datetime format, what i see in the db is 4/01/2022. Could i make some changes in the DTS package or perhaps use another Data...- prav5110
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
MYSQL Timeout Issue
HI Guys, I am trying to import a csv file(78mb) into mysql table. after a few seconds I get error 2013: connection to the server lost. I am able to break the file in parts and import to the table, but am not able to do so all at once. I guess I would have to change the server timeout option... -
MYSQL IMPORT
HI All, I am using the command line to import CSV files into a MYSQL DB. I am having problem with 1 particular file that is 84megabite. I am able to import the file if i break it into parts, however am not able to import all at once. My sql server connection looses. Could you help? thanx -
MYSQL IMPORT
HI, thanx for your help so far. Well am using windows NT . When i tried importing the csv file using script like load data infile 'C:\\LucentNonPerfRpts.csv' into table tblluc_non_perf fields terminated by ',' enclosed by '"' lines terminated by '\r\n'; It imported only 29000 rows, now... -
Access or MYSQL
HI All, We are currently using an Access DB that is updated each night. Our DB is increasing rapidly so am thinking of moving to a MYSQL DB. Myself having not much exp with Database admin stuff, could you advise whether I am thinking and moving in the right direction? I plan to create a DB in... -
MYSQL IMPORT
HI Guys, AM importing a CSV file having 136000 rows to access DB, the import takes place in 2 mins. When I do the same to an MYSQL server table, it imports 54000 records only and that too in 1 hr. Could you help?
