Hi
Having trouble filling a datetime filed in SQL table with a value from an
array.
The original source is a comma-delimited text file where the date and time
values are in two columns. I require to combine the two colums into one
datetime field in the SQL table
Here is what I am doing
FileOpen(1, my_file_to_validate, OpenMode.Binary)
MyArray = New String(My_RecordCount - 1, 38) {}
For row = 0 To My_RecordCount - 1
myrecord = LineInput(1)
Dim x = Split(myrecord, ",")
Dim MyItemDate as Date
MyItemDate = New Date(Microsoft.VisualBasic.Left(x(3), 4), _
Microsoft.VisualBasic.Mid(x(3), 5, 2), _
Microsoft.VisualBasic.Right(x(3), 2), _
Microsoft.VisualBasic.Left(x(2), 2), _
Microsoft.VisualBasic.Mid(x(2), 3, 2), _
Microsoft.VisualBasic.Mid(x(2), 5, 2))
MyArray_Array(row, 2) = CallDate
The above opens the text file and populates the array
....and when that is completed the following is supposed to take the date
value from array and insert it into the SQL table .... BUT ..... I receive
errors at the "myCommand.ExecuteNonQuery()" line indiacting that the value
cannot be accepted because it is not the right format and cannot be converted.
For i = 0 To UBound(MyArray)
myConnection = New SqlConnection _
("Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|" _
+ "\Beta_MyInfo.mdf;Integrated Security=True;User
Instance=True")
myConnection.Open()
insertCMD = "Insert into MyLog (Date) values ('" &
MyArray(i, 2) & "');"
myCommand = New SqlCommand(insertCMD, myConnection)
myCommand.ExecuteNonQuery()
myConnection.Close()
Next
Any ideas where I might be going wrong
Thanks
Michael Bond
5  1557 
MyArray appears to be just strings, perhaps MyArray(x,2) is not a valid
date?
You can test that the field is properly populated.
myConnection = New Data.SqlClient.SqlConnection _
("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|" _
+ "\Beta_MyInfo.mdf;Integrated Security=True;User
Instance=True")
Dim trans As SqlClient.SqlTransaction 'Transaction object
Dim myCommand As SqlClient.SqlCommand '
Dim insertCMD As String 'SQL String,
' consider using paramaters as they
are more
' porable over versions of RDBMS
Dim iRet As Integer 'Test that every insert inserted
one record
Dim AllClear As Boolean 'Tests for completeness
'Set flag
AllClear = True
'Open connection
myConnection.Open()
'Create a transaction
trans = myConnection.BeginTransaction
'Loop over fields to be inserted
For i As Integer = 0 To UBound(MyArray)
Try
'Test our fields
Debug.Assert(IsDate(MyArray(i, 2)) = True, "Invalid value
specified"))
Trace.WriteLineIf(IsDate(MyArray(i, 2)) = True, "Invalid value
specified"))
'Populate sql
insertCMD = String.Format("Insert into MyLog (Date) values
('{0}');", MyArray(i, 2))
'Initialize our command object
myCommand = New SqlClient.SqlCommand(insertCMD, myConnection, trans)
'Execute our SQL
iRet = myCommand.ExecuteNonQuery()
myCommand.Dispose()
'Test results
Debug.Assert(iRet = 1, String.Format("Expected one record to be
inserted, instead {0} were inserted.", iRet))
Trace.WriteLineIf(iRet = 1, String.Format("Expected one record to be
inserted, instead {0} were inserted.", iRet))
Catch ex As SqlClient.SqlException
AllClear = False
'Clean up
myCommand.Dispose()
Dim cmd As SqlClient.SqlCommand
cmd = New SqlClient.SqlCommand()
cmd.Connection = myConnection : cmd.Transaction = trans :
cmd.Transaction.Rollback()
cmd.Dispose()
Exit For
Catch ex As Exception
'Something more bad happened here.
AllClear = False
End Try
Next
If AllClear Then
Dim cmd As SqlClient.SqlCommand
cmd = New SqlClient.SqlCommand()
cmd.Connection = myConnection : cmd.Transaction = trans :
cmd.Transaction.Commit()
cmd.Dispose()
End If
myConnection.Close()
myConnection.Dispose()
"mabond" <ma****@discussions.microsoft.comwrote in message
news:3A**********************************@microsof t.com...
Hi
Having trouble filling a datetime filed in SQL table with a value from an
array.
The original source is a comma-delimited text file where the date and time
values are in two columns. I require to combine the two colums into one
datetime field in the SQL table
Here is what I am doing
FileOpen(1, my_file_to_validate, OpenMode.Binary)
MyArray = New String(My_RecordCount - 1, 38) {}
For row = 0 To My_RecordCount - 1
myrecord = LineInput(1)
Dim x = Split(myrecord, ",")
Dim MyItemDate as Date
MyItemDate = New Date(Microsoft.VisualBasic.Left(x(3), 4),
_
Microsoft.VisualBasic.Mid(x(3), 5, 2), _
Microsoft.VisualBasic.Right(x(3), 2), _
Microsoft.VisualBasic.Left(x(2), 2), _
Microsoft.VisualBasic.Mid(x(2), 3, 2), _
Microsoft.VisualBasic.Mid(x(2), 5, 2))
MyArray_Array(row, 2) = CallDate
The above opens the text file and populates the array
...and when that is completed the following is supposed to take the date
value from array and insert it into the SQL table .... BUT ..... I receive
errors at the "myCommand.ExecuteNonQuery()" line indiacting that the value
cannot be accepted because it is not the right format and cannot be
converted.
For i = 0 To UBound(MyArray)
myConnection = New SqlConnection _
("Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|" _
+ "\Beta_MyInfo.mdf;Integrated Security=True;User
Instance=True")
myConnection.Open()
insertCMD = "Insert into MyLog (Date) values ('" &
MyArray(i, 2) & "');"
myCommand = New SqlCommand(insertCMD, myConnection)
myCommand.ExecuteNonQuery()
myConnection.Close()
Next
Any ideas where I might be going wrong
Thanks
Michael Bond
erm ..... not sure how that helps. I already know the field is not being
populated because I get an error
The content of MyArray(i,2) (i being 0 for the first record) reads exactly
as follows:
"13/08/2006 00:00:15" ..... so my question is how do I get my code to write
that in such a way as it will be recognised as a valid datetime for a
datetime field in SQL
To ensure I have a date value I have tried the following
dim mydate as date
mydate = myarray(i,2)
This gives an exact value to the variable which reads
"#8/13/2006 00:00:15 AM#"
But I can't find the correct syntax to put that variable into my insert
command
insertCMD = "Insert into CallLog (Date) values calldate;"
insertCMD = "Insert into CallLog (Date) values (calldate);"
insertCMD = "Insert into CallLog (Date) values ("calldate");"
do not work
Michael
"AMDRIT" wrote:
MyArray appears to be just strings, perhaps MyArray(x,2) is not a valid
date?
You can test that the field is properly populated.
myConnection = New Data.SqlClient.SqlConnection _
("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|" _
+ "\Beta_MyInfo.mdf;Integrated Security=True;User
Instance=True")
Dim trans As SqlClient.SqlTransaction 'Transaction object
Dim myCommand As SqlClient.SqlCommand '
Dim insertCMD As String 'SQL String,
' consider using paramaters as they
are more
' porable over versions of RDBMS
Dim iRet As Integer 'Test that every insert inserted
one record
Dim AllClear As Boolean 'Tests for completeness
'Set flag
AllClear = True
'Open connection
myConnection.Open()
'Create a transaction
trans = myConnection.BeginTransaction
'Loop over fields to be inserted
For i As Integer = 0 To UBound(MyArray)
Try
'Test our fields
Debug.Assert(IsDate(MyArray(i, 2)) = True, "Invalid value
specified"))
Trace.WriteLineIf(IsDate(MyArray(i, 2)) = True, "Invalid value
specified"))
'Populate sql
insertCMD = String.Format("Insert into MyLog (Date) values
('{0}');", MyArray(i, 2))
'Initialize our command object
myCommand = New SqlClient.SqlCommand(insertCMD, myConnection, trans)
'Execute our SQL
iRet = myCommand.ExecuteNonQuery()
myCommand.Dispose()
'Test results
Debug.Assert(iRet = 1, String.Format("Expected one record to be
inserted, instead {0} were inserted.", iRet))
Trace.WriteLineIf(iRet = 1, String.Format("Expected one record to be
inserted, instead {0} were inserted.", iRet))
Catch ex As SqlClient.SqlException
AllClear = False
'Clean up
myCommand.Dispose()
Dim cmd As SqlClient.SqlCommand
cmd = New SqlClient.SqlCommand()
cmd.Connection = myConnection : cmd.Transaction = trans :
cmd.Transaction.Rollback()
cmd.Dispose()
Exit For
Catch ex As Exception
'Something more bad happened here.
AllClear = False
End Try
Next
If AllClear Then
Dim cmd As SqlClient.SqlCommand
cmd = New SqlClient.SqlCommand()
cmd.Connection = myConnection : cmd.Transaction = trans :
cmd.Transaction.Commit()
cmd.Dispose()
End If
myConnection.Close()
myConnection.Dispose()
"mabond" <ma****@discussions.microsoft.comwrote in message
news:3A**********************************@microsof t.com...
Hi
Having trouble filling a datetime filed in SQL table with a value from an
array.
The original source is a comma-delimited text file where the date and time
values are in two columns. I require to combine the two colums into one
datetime field in the SQL table
Here is what I am doing
FileOpen(1, my_file_to_validate, OpenMode.Binary)
MyArray = New String(My_RecordCount - 1, 38) {}
For row = 0 To My_RecordCount - 1
myrecord = LineInput(1)
Dim x = Split(myrecord, ",")
Dim MyItemDate as Date
MyItemDate = New Date(Microsoft.VisualBasic.Left(x(3), 4),
_
Microsoft.VisualBasic.Mid(x(3), 5, 2), _
Microsoft.VisualBasic.Right(x(3), 2), _
Microsoft.VisualBasic.Left(x(2), 2), _
Microsoft.VisualBasic.Mid(x(2), 3, 2), _
Microsoft.VisualBasic.Mid(x(2), 5, 2))
MyArray_Array(row, 2) = CallDate
The above opens the text file and populates the array
...and when that is completed the following is supposed to take the date
value from array and insert it into the SQL table .... BUT ..... I receive
errors at the "myCommand.ExecuteNonQuery()" line indiacting that the value
cannot be accepted because it is not the right format and cannot be
converted.
For i = 0 To UBound(MyArray)
myConnection = New SqlConnection _
("Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|" _
+ "\Beta_MyInfo.mdf;Integrated Security=True;User
Instance=True")
myConnection.Open()
insertCMD = "Insert into MyLog (Date) values ('" &
MyArray(i, 2) & "');"
myCommand = New SqlCommand(insertCMD, myConnection)
myCommand.ExecuteNonQuery()
myConnection.Close()
Next
Any ideas where I might be going wrong
Thanks
Michael Bond
SQL doesn't understand #date#, it does understand 'date'. Perhaps that is
all there is to it.
"mabond" <ma****@discussions.microsoft.comwrote in message
news:F3**********************************@microsof t.com...
erm ..... not sure how that helps. I already know the field is not being
populated because I get an error
The content of MyArray(i,2) (i being 0 for the first record) reads exactly
as follows:
"13/08/2006 00:00:15" ..... so my question is how do I get my code to
write
that in such a way as it will be recognised as a valid datetime for a
datetime field in SQL
To ensure I have a date value I have tried the following
dim mydate as date
mydate = myarray(i,2)
This gives an exact value to the variable which reads
"#8/13/2006 00:00:15 AM#"
But I can't find the correct syntax to put that variable into my insert
command
insertCMD = "Insert into CallLog (Date) values calldate;"
insertCMD = "Insert into CallLog (Date) values (calldate);"
insertCMD = "Insert into CallLog (Date) values ("calldate");"
do not work
Michael
"AMDRIT" wrote:
>MyArray appears to be just strings, perhaps MyArray(x,2) is not a valid
date?
You can test that the field is properly populated.
myConnection = New Data.SqlClient.SqlConnection _
("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|"
_
+ "\Beta_MyInfo.mdf;Integrated Security=True;User
Instance=True")
Dim trans As SqlClient.SqlTransaction 'Transaction object
Dim myCommand As SqlClient.SqlCommand '
Dim insertCMD As String 'SQL String,
' consider using paramaters as
they
are more
' porable over versions of RDBMS
Dim iRet As Integer 'Test that every insert
inserted
one record
Dim AllClear As Boolean 'Tests for completeness
'Set flag
AllClear = True
'Open connection
myConnection.Open()
'Create a transaction
trans = myConnection.BeginTransaction
'Loop over fields to be inserted
For i As Integer = 0 To UBound(MyArray)
Try
'Test our fields
Debug.Assert(IsDate(MyArray(i, 2)) = True, "Invalid value
specified"))
Trace.WriteLineIf(IsDate(MyArray(i, 2)) = True, "Invalid value
specified"))
'Populate sql
insertCMD = String.Format("Insert into MyLog (Date) values
('{0}');", MyArray(i, 2))
'Initialize our command object
myCommand = New SqlClient.SqlCommand(insertCMD, myConnection,
trans)
'Execute our SQL
iRet = myCommand.ExecuteNonQuery()
myCommand.Dispose()
'Test results
Debug.Assert(iRet = 1, String.Format("Expected one record to be
inserted, instead {0} were inserted.", iRet))
Trace.WriteLineIf(iRet = 1, String.Format("Expected one record to
be
inserted, instead {0} were inserted.", iRet))
Catch ex As SqlClient.SqlException
AllClear = False
'Clean up
myCommand.Dispose()
Dim cmd As SqlClient.SqlCommand
cmd = New SqlClient.SqlCommand()
cmd.Connection = myConnection : cmd.Transaction = trans :
cmd.Transaction.Rollback()
cmd.Dispose()
Exit For
Catch ex As Exception
'Something more bad happened here.
AllClear = False
End Try
Next
If AllClear Then
Dim cmd As SqlClient.SqlCommand
cmd = New SqlClient.SqlCommand()
cmd.Connection = myConnection : cmd.Transaction = trans :
cmd.Transaction.Commit()
cmd.Dispose()
End If
myConnection.Close()
myConnection.Dispose()
"mabond" <ma****@discussions.microsoft.comwrote in message
news:3A**********************************@microso ft.com...
Hi
Having trouble filling a datetime filed in SQL table with a value from
an
array.
The original source is a comma-delimited text file where the date and
time
values are in two columns. I require to combine the two colums into one
datetime field in the SQL table
Here is what I am doing
FileOpen(1, my_file_to_validate, OpenMode.Binary)
MyArray = New String(My_RecordCount - 1, 38) {}
For row = 0 To My_RecordCount - 1
myrecord = LineInput(1)
Dim x = Split(myrecord, ",")
Dim MyItemDate as Date
MyItemDate = New Date(Microsoft.VisualBasic.Left(x(3),
4),
_
Microsoft.VisualBasic.Mid(x(3), 5, 2), _
Microsoft.VisualBasic.Right(x(3), 2), _
Microsoft.VisualBasic.Left(x(2), 2), _
Microsoft.VisualBasic.Mid(x(2), 3, 2), _
Microsoft.VisualBasic.Mid(x(2), 5, 2))
MyArray_Array(row, 2) = CallDate
The above opens the text file and populates the array
...and when that is completed the following is supposed to take the
date
value from array and insert it into the SQL table .... BUT ..... I
receive
errors at the "myCommand.ExecuteNonQuery()" line indiacting that the
value
cannot be accepted because it is not the right format and cannot be
converted.
For i = 0 To UBound(MyArray)
myConnection = New SqlConnection _
("Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|" _
+ "\Beta_MyInfo.mdf;Integrated Security=True;User
Instance=True")
myConnection.Open()
insertCMD = "Insert into MyLog (Date) values ('" &
MyArray(i, 2) & "');"
myCommand = New SqlCommand(insertCMD, myConnection)
myCommand.ExecuteNonQuery()
myConnection.Close()
Next
Any ideas where I might be going wrong
Thanks
Michael Bond
Hi
I've resolved the problem by the use of parameters
the following meets my needs
insertCMD = "Insert into MyLog (Date) values (@MYDATE);"
myCommand = New SqlCommand(insertCMD, myConnection)
mycommand.parameters.add(new sqlparamter("@mydate",sqldbtype.datetime))
mycommand.parameters(0).value = cdate(myarray(i,0))
myCommand.ExecuteNonQuery()
Thanks for the pointers
Michael Bond
"AMDRIT" wrote:
SQL doesn't understand #date#, it does understand 'date'. Perhaps that is
all there is to it.
"mabond" <ma****@discussions.microsoft.comwrote in message
news:F3**********************************@microsof t.com...
erm ..... not sure how that helps. I already know the field is not being
populated because I get an error
The content of MyArray(i,2) (i being 0 for the first record) reads exactly
as follows:
"13/08/2006 00:00:15" ..... so my question is how do I get my code to
write
that in such a way as it will be recognised as a valid datetime for a
datetime field in SQL
To ensure I have a date value I have tried the following
dim mydate as date
mydate = myarray(i,2)
This gives an exact value to the variable which reads
"#8/13/2006 00:00:15 AM#"
But I can't find the correct syntax to put that variable into my insert
command
insertCMD = "Insert into CallLog (Date) values calldate;"
insertCMD = "Insert into CallLog (Date) values (calldate);"
insertCMD = "Insert into CallLog (Date) values ("calldate");"
do not work
Michael
"AMDRIT" wrote:
MyArray appears to be just strings, perhaps MyArray(x,2) is not a valid
date?
You can test that the field is properly populated.
myConnection = New Data.SqlClient.SqlConnection _
("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|"
_
+ "\Beta_MyInfo.mdf;Integrated Security=True;User
Instance=True")
Dim trans As SqlClient.SqlTransaction 'Transaction object
Dim myCommand As SqlClient.SqlCommand '
Dim insertCMD As String 'SQL String,
' consider using paramaters as
they
are more
' porable over versions of RDBMS
Dim iRet As Integer 'Test that every insert
inserted
one record
Dim AllClear As Boolean 'Tests for completeness
'Set flag
AllClear = True
'Open connection
myConnection.Open()
'Create a transaction
trans = myConnection.BeginTransaction
'Loop over fields to be inserted
For i As Integer = 0 To UBound(MyArray)
Try
'Test our fields
Debug.Assert(IsDate(MyArray(i, 2)) = True, "Invalid value
specified"))
Trace.WriteLineIf(IsDate(MyArray(i, 2)) = True, "Invalid value
specified"))
'Populate sql
insertCMD = String.Format("Insert into MyLog (Date) values
('{0}');", MyArray(i, 2))
'Initialize our command object
myCommand = New SqlClient.SqlCommand(insertCMD, myConnection,
trans)
'Execute our SQL
iRet = myCommand.ExecuteNonQuery()
myCommand.Dispose()
'Test results
Debug.Assert(iRet = 1, String.Format("Expected one record to be
inserted, instead {0} were inserted.", iRet))
Trace.WriteLineIf(iRet = 1, String.Format("Expected one record to
be
inserted, instead {0} were inserted.", iRet))
Catch ex As SqlClient.SqlException
AllClear = False
'Clean up
myCommand.Dispose()
Dim cmd As SqlClient.SqlCommand
cmd = New SqlClient.SqlCommand()
cmd.Connection = myConnection : cmd.Transaction = trans :
cmd.Transaction.Rollback()
cmd.Dispose()
Exit For
Catch ex As Exception
'Something more bad happened here.
AllClear = False
End Try
Next
If AllClear Then
Dim cmd As SqlClient.SqlCommand
cmd = New SqlClient.SqlCommand()
cmd.Connection = myConnection : cmd.Transaction = trans :
cmd.Transaction.Commit()
cmd.Dispose()
End If
myConnection.Close()
myConnection.Dispose()
"mabond" <ma****@discussions.microsoft.comwrote in message
news:3A**********************************@microsof t.com...
Hi
Having trouble filling a datetime filed in SQL table with a value from
an
array.
The original source is a comma-delimited text file where the date and
time
values are in two columns. I require to combine the two colums into one
datetime field in the SQL table
Here is what I am doing
FileOpen(1, my_file_to_validate, OpenMode.Binary)
MyArray = New String(My_RecordCount - 1, 38) {}
For row = 0 To My_RecordCount - 1
myrecord = LineInput(1)
Dim x = Split(myrecord, ",")
Dim MyItemDate as Date
MyItemDate = New Date(Microsoft.VisualBasic.Left(x(3),
4),
_
Microsoft.VisualBasic.Mid(x(3), 5, 2), _
Microsoft.VisualBasic.Right(x(3), 2), _
Microsoft.VisualBasic.Left(x(2), 2), _
Microsoft.VisualBasic.Mid(x(2), 3, 2), _
Microsoft.VisualBasic.Mid(x(2), 5, 2))
MyArray_Array(row, 2) = CallDate
The above opens the text file and populates the array
...and when that is completed the following is supposed to take the
date
value from array and insert it into the SQL table .... BUT ..... I
receive
errors at the "myCommand.ExecuteNonQuery()" line indiacting that the
value
cannot be accepted because it is not the right format and cannot be
converted.
For i = 0 To UBound(MyArray)
myConnection = New SqlConnection _
("Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|" _
+ "\Beta_MyInfo.mdf;Integrated Security=True;User
Instance=True")
myConnection.Open()
insertCMD = "Insert into MyLog (Date) values ('" &
MyArray(i, 2) & "');"
myCommand = New SqlCommand(insertCMD, myConnection)
myCommand.ExecuteNonQuery()
myConnection.Close()
Next
Any ideas where I might be going wrong
Thanks
Michael Bond
Using a parameter was the right way of fixing it. You should never
send a SQL string directly. You should create a stored procedure and
pass in the values to the UPDATE and let the server handle it. Or, in
your case, the INSERT.
mabond wrote:
Hi
I've resolved the problem by the use of parameters
the following meets my needs
insertCMD = "Insert into MyLog (Date) values (@MYDATE);"
myCommand = New SqlCommand(insertCMD, myConnection)
mycommand.parameters.add(new sqlparamter("@mydate",sqldbtype.datetime))
mycommand.parameters(0).value = cdate(myarray(i,0))
myCommand.ExecuteNonQuery()
Thanks for the pointers
Michael Bond
"AMDRIT" wrote:
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mike Wilcox |
last post by:
I use the following code snippet to build a drop down menu with the
results of a query. How can I set the initial value of this input based
on the result of another query?
What I am trying to do...
|
by: Broder |
last post by:
Hi there,
I am currently running into a somewhat weired problem and hope that this NG
is able to help ;-)
I have a table in a MSSQL Server in which there is one Column that stores a
date. The...
|
by: |
last post by:
Trying to learn about manipulating collections of objects, and populating
these objects dynamically from datasources. Could someone post a code sample
that shows the following:
Instantiating a...
|
by: sck10 |
last post by:
Hello,
I am creating a form for users to enter information about a lab and the
members of the lab. I have one form (FormView) that they use to enter
information about that lab. The keyvalue is...
|
by: MLH |
last post by:
http://www.opm.gov/Fedhol/
http://www.opm.gov/Fedhol/2008.asp
Federal law (5 U.S.C. 6103) establishes the following public holidays
for Federal employees. Please note that most Federal employees...
|
by: dozingquinn |
last post by:
Hello,
Is there any way to auto populate the user defined date range into a report? I currently have the criteria "Between And " for a date range field. This prompts the user to enter a date...
|
by: kimgclark |
last post by:
I am trying to get a date that calculate in the control source on a form to update a field in a table. The formula works but does not update the table.
This is what I am using: ...
|
by: Ed Bitzer |
last post by:
Appreciate some direction on populating an unbound DataGridView with
an one dimensional array of date an appointments (a calendar) read
from a coma delimited text file. My original approach was to...
|
by: dupontk |
last post by:
Here it is I have four fields on a form that come from a query. Fields a,b,c,d.
a is a text field that looks like a date 1/2/2009, b is a time that looks like 8:00:00 AM and c is a concatanated...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
