the sql table is already set up with about 15 fields.  I need to import a file that has about 100 rows of information that goes into only 3 of those fields for each row.
121777
Depends on the file that needs to be imported, and how you need to import it.  Enterprise manger comes with an import wizard that you can use to import information.  sometimes it's easier to just import the whole thing and delete what you don't need/want.\n\nanother way would be to make the file into a CVS and import that into access, then by using a linked table, export the table to SQL.
29944
Actually when you're in Excel you can add a Visual Basic line that makes a SQL query that selects one random name. I don't know the particulars, but I know it's really really easy and it's literally one line of code or two.\nYou could also have two excel files, and one of them acts as a "filter" of sorts, by bringing "external data" from the second one and filtering with the SQL statement.
480646
Assuming you are on Oracle DB (why not, about 80-90% are)...\n\nThis should try and help you:\n\nSELECT * FROM YOURTABLE WHERE LENGTH(TEL_HP) <> SOMENUMBER;\n\nThe above should give you a list of rows where TEL_HP is NOT EQUAL to the character length you are looking for.  \n\nFrom there you can nest that into an INSERT statement after you create a similar table.\n\nExample,\n\nINSERT INTO NEWTABLE (SELECT * FROM YOURTABLE WHERE LENGTH(TEL_HP) <> SOMENUMBER)
273745
For this you can use SQL loader option to load external data to the oracle database.In this(SQL loader) you have option to load n-number of files to oracle database in single selection.
596503
Dude... whoever said "use the connection wizard" just isn't creative at all...\n---------------------------------------------------------\n\nHere is code that helps you get started:\n\npublic DataTable listExistingForAdmin()\n{\n//a temporary table for storing the data into a dataset\nstring temptable = "yourTableNameHere";\n\n//prepare the SQL statement...\nstring sql = "EXEC df_groups_listExistingForAdmin"; //your SQL code here\n\n//open the connection - use your connection string!!!\nthis.con = new SqlConnection("packet size=4096;user id=dbuser;password=dbuser;data source=YourDbServerName;persist security info=False;initial catalog=yourDbName");\nthis.con.Open();\n\n//instantiate the command\nthis.com = new SqlCommand(sql, this.con);\nthis.com.CommandText = sql;\n\n//instantiate the data adapter\nSqlDataAdapter adapt = new SqlDataAdapter();\nadapt.SelectCommand = this.com;\n\n//instantiate the DataSet\nDataSet ds = new DataSet();\n\n//complete the transaction\nadapt.Fill(ds, temptable);\nDataTable dt = ds.Tables[temptable];\n\n//clean house\nadapt.Dispose();\nthis.com.Dispose();\nthis.con.Close();\n\nreturn dt;\n}//end ()\n\nHope this helps!!
422655
I havn't done it mysqlf but a good place to start is with the TI-83 SDK and the documentation. The headers and required includes usually have a lot of information on how they can be used and often have a brief tutorial/starter project to build off of.
504484
CREATE TABLE cus_tmp as (SELECT * FROM members WHERE tel_hp LIKE '% - %');\n\nAll you are missing is the ().\n\nEnjoy -
296331
Try using a datagrid. You can use SqlDataReader object and populate the datagrid.
488064
mySQL should be part of your solution.\n///
643801
Skip calling the stored proc and use a cursor to grab the rows directly and insert them into the second table.\n\nExample cursor:\n--------------------------\nDECLARE @col1_value VARCHAR(100)\nDECLARE @col2_value VARCHAR(100)\n\nDECLARE cc CURSOR FOR\nSELECT col1, col2\nFROM table1\n\nOPEN cc\n\nFETCH NEXT FROM cc INTO @col1_value, @col2_value\n\nWHILE @@FETCH_STATUS=0\nBEGIN\n\nINSERT INTO table2 (column1, column2)\nVALUES @col1_value, @col2_value\n\nEND\n\nCLOSE cc\nDEALLOCATE cc\n--------------------------
332321
If you have a 1 to many relationship all you need to do is select the corresponding key and then loop to insert the rest of the records into the second table. For example. \n\nuser table\nuserid as int\nuname as varchar(50)\notherdata\nother data\n\nphonenumber table\nuserid as int\nphone as varchar(16)\n\nTo insert three phone numebrs for user John Doe you so a \nselect userid from user where name = "John Doe" ;\n\nNow that you have the userid, assuming they are in an array. \nfor i = 1 to number_of_phonerecs\n   insert into phonenumber values (varuserid,varphone(i));\nnext\n\nExcuse my SQL as it's late and this is an oversimplified example.
674439
1. Simply open up the database.\n\n2. Make sure that you're looking at the database window (F-11)\n\n3. Hit file / Get External Data / Import\n\nA wizard will open up and you can select the other database that you want to import.\n\nThis works well, but does not import database properties, and you might have some trouble if you have different version of MS Access databases
73841
Um.. check out this tutorial \n- updating multiple mysql records\nhttp://www.phpeasystep.com/mysqlview.php?id=10\n\nhope it help.
628007
Use the 'Query Analyzer' in Acess to select each field from each table then go to SQL view to copy and paste the SQL code you need.
60062
Sorry, I don't think I can help.  I can use a 50 field table in Access and create a 50 field form using the wizard.\n\nDoes the problem occur running the wizard locally instead of through the thin client?  If it doesn't, you probably need to report the problem to Wyse.\n\nOnly other thing I can suggest (not saying it will make a difference) is see if you have the latest service pack installed for Office - maybe there was a bug???
85010
Make sure you call the Read() method on your reader before you attempt to assign its values to your label.\n\nDim objConn As New SqlConnection(connString)\nDim objCmd As New SqlCommand("spMyProcedure", objConn)\nobjCmd.CommandType = CommandType.StoredProcedure\nDim objReader As new SqlDataReader\n\nobjConn.Open()\nobjReader = objCmd.ExecuteReader()\nobjReader.Read()\nlabel1.Text - objReader("columnname")\nobjConn.Close()\n\nobjCmd.Dispose()\nobjConn.Dispose()
475916
if you know 2003, you should have the answer to this.  You have to post the form back to the same page (add a button with a method like btnSubmit_Click(object sender, EventArgs e).  Once this the page is posted back, you then need to create a database connection.\n\nYour SQL connection string should be saved in your web.config file.\n\nusing System.Data.SqlClient;\n\nSqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);\nSqlCommand cmd = new SqlCommand("INSERT INTO TABLENAME (Column1, Column2, Column3) VALUES (" + "'" + txtColun1 + "'" + "," + "'" + txtColumn2 + "'" + "," + "'" + txtColumn3 + "'" + ")", con);\ntry\n{\n   cmd.ExecuteNonQuery();\n}\ncatch(SqlException e)\n{\n  string error = e.Message.ToString();\n}\nfinally\n{\n  con.close();\n}\n\nThe only change is that VS 2003 use to use:\nSqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["con"]);  This is now obsolete.\n\nSorry, I updated this because yahoo answers cut have my code off.