Text file as a datasource

Chris

Hi

I can use a text file as a datasource but am unable to get the datatable to
see the text file as having multiple columns. Everything gets
put into the first column in the datatable. Sample of code and text file
included.

Please help

Regards
Chris

Public Function ImportTextFile(ByVal Path As String, ByVal File As String)
As String

Dim txtConStr As String
Dim txtoleCon As OleDb.OleDbConnection
Dim txtoleAdapter As OleDb.OleDbDataAdapter
Dim txtdataset As DataSet
Dim txtdatarow As DataRow

Try
Dim f As System.IO.File
If f.Exists(Path & "\" & File) Then

'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Eng ines\Text\FirstRowHasNames
=00 (00=False) (01=True)
txtConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
& Path & ";Extended Properties=Text;"
txtoleCon = New OleDb.OleDbConnection(txtConStr)
txtoleCon.Open()
txtoleAdapter = New OleDb.OleDbDataAdapter("Select * from "
& File, txtoleCon)
txtoleAdapter.SelectCommand.ExecuteNonQuery()
txtdataset = New DataSet
txtoleAdapter.Fill(txtdataset, "TextFile")
For Each txtdatarow In txtdataset.Tables(0).Rows
Me.lbRecords.Items.Add(txtdatarow.Item(0))
Next
txtoleCon.Close()
Return "True"
Else
Return "File Not Found"
End If
Catch ex As Exception
Return False
Finally
txtdataset = Nothing
txtoleAdapter = Nothing
txtoleCon = Nothing
End Try

End Function

'Text File Sample
11966 GAS_SMP 2003/11/27 17:06:00 000 0.0
11966 GAS_SMP 2003/11/27 17:07:00 000 0.0
11966 GAS_SMP 2003/11/27 17:08:00 000 0.0
11966 GAS_SMP 2003/11/27 17:09:00 000 0.0
11966 GAS_SMP 2003/11/27 17:10:00 000 0.0
11966 GAS_SMP 2003/11/27 17:11:00 000 0.0
11966 GAS_SMP 2003/11/27 17:12:00 000 0.0
11966 GAS_SMP 2003/11/27 17:13:00 000 0.0
11966 GAS_SMP 2003/11/27 17:14:00 000 0.0
11966 GAS_SMP 2003/11/27 17:15:00 000 0.0
11966 GAS_SMP 2003/11/27 17:16:00 000 0.0
11966 GAS_SMP 2003/11/27 17:17:00 000 0.0

Nov 20 '05 #1

Subscribe Post Reply

4278

One Handed Man [ OHM ]

Post your code and a section of the text file for input.

Regards - OHM
Chris wrote:

Hi

I can use a text file as a datasource but am unable to get the
datatable to see the text file as having multiple columns. Everything
gets
put into the first column in the datatable. Sample of code and text
file included.

Please help

Regards
Chris

Public Function ImportTextFile(ByVal Path As String, ByVal File As
String) As String

Dim txtConStr As String
Dim txtoleCon As OleDb.OleDbConnection
Dim txtoleAdapter As OleDb.OleDbDataAdapter
Dim txtdataset As DataSet
Dim txtdatarow As DataRow

Try
Dim f As System.IO.File
If f.Exists(Path & "\" & File) Then

'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Eng ines\Text\FirstRowHasNames =00 (00=False) (01=True)
txtConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" & Path & ";Extended Properties=Text;"
txtoleCon = New OleDb.OleDbConnection(txtConStr)
txtoleCon.Open()
txtoleAdapter = New OleDb.OleDbDataAdapter("Select *
from " & File, txtoleCon)
txtoleAdapter.SelectCommand.ExecuteNonQuery()
txtdataset = New DataSet
txtoleAdapter.Fill(txtdataset, "TextFile")
For Each txtdatarow In txtdataset.Tables(0).Rows
Me.lbRecords.Items.Add(txtdatarow.Item(0))
Next
txtoleCon.Close()
Return "True"
Else
Return "File Not Found"
End If
Catch ex As Exception
Return False
Finally
txtdataset = Nothing
txtoleAdapter = Nothing
txtoleCon = Nothing
End Try

End Function

'Text File Sample
11966 GAS_SMP 2003/11/27 17:06:00 000 0.0
11966 GAS_SMP 2003/11/27 17:07:00 000 0.0
11966 GAS_SMP 2003/11/27 17:08:00 000 0.0
11966 GAS_SMP 2003/11/27 17:09:00 000 0.0
11966 GAS_SMP 2003/11/27 17:10:00 000 0.0
11966 GAS_SMP 2003/11/27 17:11:00 000 0.0
11966 GAS_SMP 2003/11/27 17:12:00 000 0.0
11966 GAS_SMP 2003/11/27 17:13:00 000 0.0
11966 GAS_SMP 2003/11/27 17:14:00 000 0.0
11966 GAS_SMP 2003/11/27 17:15:00 000 0.0
11966 GAS_SMP 2003/11/27 17:16:00 000 0.0
11966 GAS_SMP 2003/11/27 17:17:00 000 0.0

Best Regards - OHMBest Regards - OHM On**********@BTInternet.Com

Nov 20 '05 #2

RDI

"Thats REALLY WEIRD !!!"--yeah, that's a good way to describe it. I've seen
some STRANGE things in the past too.

"One Handed Man [ OHM ]" <te***************************@BTOpenworld.com>
wrote in message news:%2****************@TK2MSFTNGP11.phx.gbl...

Thats REALLY WEIRD !!!, I could not see this on the previous post, But I see in here ;-\

OK, i'll look.

OHM

RDI wrote:
ohm,

I can see the code and sample text source. It's part of the message.

"One Handed Man [ OHM ]"
<te***************************@BTOpenworld.com> wrote in message
news:Ol**************@TK2MSFTNGP11.phx.gbl...
Post your code and a section of the text file for input.

Regards - OHM
Chris wrote:
Hi

I can use a text file as a datasource but am unable to get the
datatable to see the text file as having multiple columns.
Everything gets
put into the first column in the datatable. Sample of code and text
file included.

Please help

Regards
Chris

Public Function ImportTextFile(ByVal Path As String, ByVal File As
String) As String

Dim txtConStr As String
Dim txtoleCon As OleDb.OleDbConnection
Dim txtoleAdapter As OleDb.OleDbDataAdapter
Dim txtdataset As DataSet
Dim txtdatarow As DataRow

Try
Dim f As System.IO.File
If f.Exists(Path & "\" & File) Then

'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Eng ines\Text\FirstRowHasNames

=00 (00=False) (01=True)
txtConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" & Path & ";Extended Properties=Text;"
txtoleCon = New OleDb.OleDbConnection(txtConStr)
txtoleCon.Open()
txtoleAdapter = New OleDb.OleDbDataAdapter("Select *
from " & File, txtoleCon)
txtoleAdapter.SelectCommand.ExecuteNonQuery()
txtdataset = New DataSet
txtoleAdapter.Fill(txtdataset, "TextFile")
For Each txtdatarow In txtdataset.Tables(0).Rows
Me.lbRecords.Items.Add(txtdatarow.Item(0))
Next
txtoleCon.Close()
Return "True"
Else
Return "File Not Found"
End If
Catch ex As Exception
Return False
Finally
txtdataset = Nothing
txtoleAdapter = Nothing
txtoleCon = Nothing
End Try

End Function

'Text File Sample
11966 GAS_SMP 2003/11/27 17:06:00 000 0.0
11966 GAS_SMP 2003/11/27 17:07:00 000 0.0
11966 GAS_SMP 2003/11/27 17:08:00 000 0.0
11966 GAS_SMP 2003/11/27 17:09:00 000 0.0
11966 GAS_SMP 2003/11/27 17:10:00 000 0.0
11966 GAS_SMP 2003/11/27 17:11:00 000 0.0
11966 GAS_SMP 2003/11/27 17:12:00 000 0.0
11966 GAS_SMP 2003/11/27 17:13:00 000 0.0
11966 GAS_SMP 2003/11/27 17:14:00 000 0.0
11966 GAS_SMP 2003/11/27 17:15:00 000 0.0
11966 GAS_SMP 2003/11/27 17:16:00 000 0.0
11966 GAS_SMP 2003/11/27 17:17:00 000 0.0

Best Regards - OHMBest Regards - OHM On**********@BTInternet.Com

Best Regards - OHMBest Regards - OHM On**********@BTInternet.Com

Nov 20 '05 #3

One Handed Man [ OHM ]

Anyway,
The first problem you have is that the file will not parse
on spaces, you need to delimit the file with commas. That way at least the
data rows will then be split. You can see this if you breakpoint your loop
and look at the datarow variable.

After that, its a matter of getting the data into a control. I'm not sure if
listbox ( if thats what you are using ) is the best for this. I would have
used a datagrid and bound it to the dataset personally. Much easier.

Regards - OHM

RDI wrote:

"Thats REALLY WEIRD !!!"--yeah, that's a good way to describe it.
I've seen some STRANGE things in the past too.

"One Handed Man [ OHM ]"
<te***************************@BTOpenworld.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
Thats REALLY WEIRD !!!, I could not see this on the previous post,
But I see in here ;-\

OK, i'll look.

OHM

RDI wrote:
ohm,

I can see the code and sample text source. It's part of the
message.

"One Handed Man [ OHM ]"
<te***************************@BTOpenworld.com> wrote in message
news:Ol**************@TK2MSFTNGP11.phx.gbl...
Post your code and a section of the text file for input.

Regards - OHM
Chris wrote:
> Hi
>
> I can use a text file as a datasource but am unable to get the
> datatable to see the text file as having multiple columns.
> Everything gets
> put into the first column in the datatable. Sample of code and
> text file included.
>
> Please help
>
> Regards
> Chris
>
> Public Function ImportTextFile(ByVal Path As String, ByVal File As
> String) As String
>
> Dim txtConStr As String
> Dim txtoleCon As OleDb.OleDbConnection
> Dim txtoleAdapter As OleDb.OleDbDataAdapter
> Dim txtdataset As DataSet
> Dim txtdatarow As DataRow
>
> Try
> Dim f As System.IO.File
> If f.Exists(Path & "\" & File) Then
>
>

'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Eng ines\Text\FirstRowHasNames

> =00 (00=False) (01=True)
> txtConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=" & Path & ";Extended Properties=Text;"
> txtoleCon = New OleDb.OleDbConnection(txtConStr)
> txtoleCon.Open()
> txtoleAdapter = New
> OleDb.OleDbDataAdapter("Select * from " & File, txtoleCon)
> txtoleAdapter.SelectCommand.ExecuteNonQuery()
> txtdataset = New DataSet
> txtoleAdapter.Fill(txtdataset, "TextFile")
> For Each txtdatarow In txtdataset.Tables(0).Rows
> Me.lbRecords.Items.Add(txtdatarow.Item(0))
> Next
> txtoleCon.Close()
> Return "True"
> Else
> Return "File Not Found"
> End If
> Catch ex As Exception
> Return False
> Finally
> txtdataset = Nothing
> txtoleAdapter = Nothing
> txtoleCon = Nothing
> End Try
>
> End Function
>
> 'Text File Sample
> 11966 GAS_SMP 2003/11/27 17:06:00 000 0.0
> 11966 GAS_SMP 2003/11/27 17:07:00 000 0.0
> 11966 GAS_SMP 2003/11/27 17:08:00 000 0.0
> 11966 GAS_SMP 2003/11/27 17:09:00 000 0.0
> 11966 GAS_SMP 2003/11/27 17:10:00 000 0.0
> 11966 GAS_SMP 2003/11/27 17:11:00 000 0.0
> 11966 GAS_SMP 2003/11/27 17:12:00 000 0.0
> 11966 GAS_SMP 2003/11/27 17:13:00 000 0.0
> 11966 GAS_SMP 2003/11/27 17:14:00 000 0.0
> 11966 GAS_SMP 2003/11/27 17:15:00 000 0.0
> 11966 GAS_SMP 2003/11/27 17:16:00 000 0.0
> 11966 GAS_SMP 2003/11/27 17:17:00 000 0.0

Best Regards - OHMBest Regards - OHM On**********@BTInternet.Com

Best Regards - OHMBest Regards - OHM On**********@BTInternet.Com

Best Regards - OHMBest Regards - OHM On**********@BTInternet.Com

Nov 20 '05 #4

Paul Clement

On Mon, 1 Dec 2003 15:29:33 +0200, "Chris" <cg******@webmail.co.za> wrote:

¤ Hi
¤
¤ I can use a text file as a datasource but am unable to get the datatable to
¤ see the text file as having multiple columns. Everything gets
¤ put into the first column in the datatable. Sample of code and text file
¤ included.
¤

<snip>

¤
¤ 'Text File Sample
¤ 11966 GAS_SMP 2003/11/27 17:06:00 000 0.0
¤ 11966 GAS_SMP 2003/11/27 17:07:00 000 0.0
¤ 11966 GAS_SMP 2003/11/27 17:08:00 000 0.0
¤ 11966 GAS_SMP 2003/11/27 17:09:00 000 0.0
¤ 11966 GAS_SMP 2003/11/27 17:10:00 000 0.0
¤ 11966 GAS_SMP 2003/11/27 17:11:00 000 0.0
¤ 11966 GAS_SMP 2003/11/27 17:12:00 000 0.0
¤ 11966 GAS_SMP 2003/11/27 17:13:00 000 0.0
¤ 11966 GAS_SMP 2003/11/27 17:14:00 000 0.0
¤ 11966 GAS_SMP 2003/11/27 17:15:00 000 0.0
¤ 11966 GAS_SMP 2003/11/27 17:16:00 000 0.0
¤ 11966 GAS_SMP 2003/11/27 17:17:00 000 0.0
¤

Custom field delimited files require a schema.ini file. Since your fields are space delimited:

[Order.txt]
ColNameHeader=False
Format=Delimited( )
CharacterSet=ANSI

The schema.ini file resides in the same location at your text file.

http://msdn.microsoft.com/library/de...cjetsdk_98.asp
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

Nov 20 '05 #5

-----Original Message-----
Hi

I can use a text file as a datasource but am unable to get the datatable tosee the text file as having multiple columns. Everything getsput into the first column in the datatable. Sample of code and text fileincluded.

Please help

Regards
Chris

Public Function ImportTextFile(ByVal Path As String, ByVal File As String)As String

Dim txtConStr As String
Dim txtoleCon As OleDb.OleDbConnection
Dim txtoleAdapter As OleDb.OleDbDataAdapter
Dim txtdataset As DataSet
Dim txtdatarow As DataRow

Try
Dim f As System.IO.File
If f.Exists(Path & "\" & File) Then

'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0 \Engines\Text\FirstRowHasNames=00 (00=False) (01=True)
txtConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& Path & ";Extended Properties=Text;"
txtoleCon = New OleDb.OleDbConnection (txtConStr) txtoleCon.Open()
txtoleAdapter = New OleDb.OleDbDataAdapter ("Select * from "& File, txtoleCon)
txtoleAdapter.SelectCommand.ExecuteNonQuery() txtdataset = New DataSet
txtoleAdapter.Fill(txtdataset, "TextFile")
For Each txtdatarow In txtdataset.Tables (0).Rows Me.lbRecords.Items.Add(txtdatarow.Item (0)) Next
txtoleCon.Close()
Return "True"
Else
Return "File Not Found"
End If
Catch ex As Exception
Return False
Finally
txtdataset = Nothing
txtoleAdapter = Nothing
txtoleCon = Nothing
End Try

End Function

'Text File Sample
11966 GAS_SMP 2003/11/27 17:06:00 000 0.0
11966 GAS_SMP 2003/11/27 17:07:00 000 0.0
11966 GAS_SMP 2003/11/27 17:08:00 000 0.0
11966 GAS_SMP 2003/11/27 17:09:00 000 0.0
11966 GAS_SMP 2003/11/27 17:10:00 000 0.0
11966 GAS_SMP 2003/11/27 17:11:00 000 0.0
11966 GAS_SMP 2003/11/27 17:12:00 000 0.0
11966 GAS_SMP 2003/11/27 17:13:00 000 0.0
11966 GAS_SMP 2003/11/27 17:14:00 000 0.0
11966 GAS_SMP 2003/11/27 17:15:00 000 0.0
11966 GAS_SMP 2003/11/27 17:16:00 000 0.0
11966 GAS_SMP 2003/11/27 17:17:00 000 0.0
.
Another way (maybe more laborious) is to read in each

line of text as a string,
use the SPLIT command with a space delimiter to break into
substrings,
then assign relevant locations in the substring array to
the relevant collumns.

when you construct your dataset call add method to place a
new table and collumns or create it from a schema which
allows fields which correspond to your expected data.

Nov 20 '05 #6

Chris

Thanks for the replies. I will test them out later

Regards
Chris

"Chris" <cg******@webmail.co.za> wrote in message
news:bq**********@ctb-nnrp2.saix.net...

Hi

I can use a text file as a datasource but am unable to get the datatable to see the text file as having multiple columns. Everything gets
put into the first column in the datatable. Sample of code and text file
included.

Please help

Regards
Chris

Public Function ImportTextFile(ByVal Path As String, ByVal File As String)
As String

Dim txtConStr As String
Dim txtoleCon As OleDb.OleDbConnection
Dim txtoleAdapter As OleDb.OleDbDataAdapter
Dim txtdataset As DataSet
Dim txtdatarow As DataRow

Try
Dim f As System.IO.File
If f.Exists(Path & "\" & File) Then

'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Eng ines\Text\FirstRowHasNames =00 (00=False) (01=True)
txtConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Path & ";Extended Properties=Text;"
txtoleCon = New OleDb.OleDbConnection(txtConStr)
txtoleCon.Open()
txtoleAdapter = New OleDb.OleDbDataAdapter("Select * from " & File, txtoleCon)
txtoleAdapter.SelectCommand.ExecuteNonQuery()
txtdataset = New DataSet
txtoleAdapter.Fill(txtdataset, "TextFile")
For Each txtdatarow In txtdataset.Tables(0).Rows
Me.lbRecords.Items.Add(txtdatarow.Item(0))
Next
txtoleCon.Close()
Return "True"
Else
Return "File Not Found"
End If
Catch ex As Exception
Return False
Finally
txtdataset = Nothing
txtoleAdapter = Nothing
txtoleCon = Nothing
End Try

End Function

'Text File Sample
11966 GAS_SMP 2003/11/27 17:06:00 000 0.0
11966 GAS_SMP 2003/11/27 17:07:00 000 0.0
11966 GAS_SMP 2003/11/27 17:08:00 000 0.0
11966 GAS_SMP 2003/11/27 17:09:00 000 0.0
11966 GAS_SMP 2003/11/27 17:10:00 000 0.0
11966 GAS_SMP 2003/11/27 17:11:00 000 0.0
11966 GAS_SMP 2003/11/27 17:12:00 000 0.0
11966 GAS_SMP 2003/11/27 17:13:00 000 0.0
11966 GAS_SMP 2003/11/27 17:14:00 000 0.0
11966 GAS_SMP 2003/11/27 17:15:00 000 0.0
11966 GAS_SMP 2003/11/27 17:16:00 000 0.0
11966 GAS_SMP 2003/11/27 17:17:00 000 0.0

Nov 20 '05 #7

Guillaume Babin-Tremblay

"Chris" <cg******@webmail.co.za> wrote in message
news:bq**********@ctb-nnrp2.saix.net...

Hi

I can use a text file as a datasource but am unable to get the datatable to see the text file as having multiple columns. Everything gets
put into the first column in the datatable. Sample of code and text file
included.

Please help

Regards
Chris

Public Function ImportTextFile(ByVal Path As String, ByVal File As String)
As String

Dim txtConStr As String
Dim txtoleCon As OleDb.OleDbConnection
Dim txtoleAdapter As OleDb.OleDbDataAdapter
Dim txtdataset As DataSet
Dim txtdatarow As DataRow

Try
Dim f As System.IO.File
If f.Exists(Path & "\" & File) Then

'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Eng ines\Text\FirstRowHasNames =00 (00=False) (01=True)
txtConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Path & ";Extended Properties=Text;"
txtoleCon = New OleDb.OleDbConnection(txtConStr)
txtoleCon.Open()
txtoleAdapter = New OleDb.OleDbDataAdapter("Select * from " & File, txtoleCon)
txtoleAdapter.SelectCommand.ExecuteNonQuery()
txtdataset = New DataSet
txtoleAdapter.Fill(txtdataset, "TextFile")
For Each txtdatarow In txtdataset.Tables(0).Rows
Me.lbRecords.Items.Add(txtdatarow.Item(0))
Next
txtoleCon.Close()
Return "True"
Else
Return "File Not Found"
End If
Catch ex As Exception
Return False
Finally
txtdataset = Nothing
txtoleAdapter = Nothing
txtoleCon = Nothing
End Try

End Function

'Text File Sample
11966 GAS_SMP 2003/11/27 17:06:00 000 0.0
11966 GAS_SMP 2003/11/27 17:07:00 000 0.0
11966 GAS_SMP 2003/11/27 17:08:00 000 0.0
11966 GAS_SMP 2003/11/27 17:09:00 000 0.0
11966 GAS_SMP 2003/11/27 17:10:00 000 0.0
11966 GAS_SMP 2003/11/27 17:11:00 000 0.0
11966 GAS_SMP 2003/11/27 17:12:00 000 0.0
11966 GAS_SMP 2003/11/27 17:13:00 000 0.0
11966 GAS_SMP 2003/11/27 17:14:00 000 0.0
11966 GAS_SMP 2003/11/27 17:15:00 000 0.0
11966 GAS_SMP 2003/11/27 17:16:00 000 0.0
11966 GAS_SMP 2003/11/27 17:17:00 000 0.0

Hmm... Do you really need to access your file by ado.net? If there is no
others constraints, I think you would get a better result with this code :
'Open a stream reader to your text file
Dim sr As New IO.StreamReader("C:\file.txt")

Dim text As String = sr.ReadToEnd 'If your text is large, you might
prefer to read it line by line

'Close stream reader
sr.Close()

'Split your text into lines
Dim lines() As String = text.Split(vbLf) 'Depending on your original
file format, you might need to split on vbCR, or vbCrLf

Dim i As Integer
For i = 0 To lines.Length - 1

'Split your line into values
Dim values() As String = lines(i).Split(" ")

'Create your datarow
Dim row As DataRow = datatable.NewRow

'Set its values
row.Item("column1") = values(0)
row.Item("column1") = values(1)
row.Item("column1") = values(2)
row.Item("column1") = values(3)
row.Item("column1") = values(4)

'Add it to table
datatable.Rows.Add(row)

Next
HTH

Guillaume Babin-Tremblay

Nov 20 '05 #8

by: Steve | last post by:

Hi, I have a table which contains records of user access and searches made within an application, this is a sample of the data: response for 101 results from database in 28906 ms I only...

Microsoft Access / VBA

Fixed Width Text File Import Programmtically

by: Johnny Meredith | last post by:

I have seven huge fixed width text file that I need to import to Access. They contain headers, subtotals, etc. that are not needed. There is also some corrupt data that we know about and can...

Microsoft Access / VBA

Textbox bind to datagrid but text doesn't change when selection ch

by: Alpha | last post by:

I have several textboxes that I need to chang the text when the selection row is changed in a datagrid. I have the following code. This textbox displayes the initial selection but when I click on...

C# / C Sharp

SQL FOR XML Query results to Text via ASP.NET

by: Rob | last post by:

I doubt this is the best way to do it, but what I came up with was to hide the XML in an HTML Comment then edit the file deleting the HTML stuff and keep the XML results. If anyone has a better...

ASP.NET

Combobox, datasource and text file

by: George | last post by:

Hi, Does anyone know how to bind text file to a datasource (of a combobox in my case)? I went through the properties, but it seems like the only "boundable" sources are databases such as...

C# / C Sharp

Data in datagridview from a text file

by: Leszek | last post by:

Hello! Is there any possibility to load a datagridview from a text file? I have *.tsv file with performance counters and I'm trying to create a webpage (or Windows application), that will show...

Visual Basic .NET

need to open text file for datapump from activex script

by: SimplySuzy | last post by:

Help I am trying to open a text file that I am naming dynamically through global variables in a dts package. When I print the file name to the screen, it is correct. When I use the dts package...

Microsoft SQL Server

Number format change to text

by: michaelw118 | last post by:

Hi, I hope someone can give me some solutions to these problems I faced. I imported some data to Excel. Then in Access, I table-linked to this file. I have two fields which in Excel is in...

Microsoft Access / VBA

Dynamic search text in datagrid

by: JamesOo | last post by:

I have the code below, but I need to make it searchable in query table, below code only allowed seach the table which in show mdb only. (i.e. have 3 table, but only can search either one only,...

Visual Basic 4 / 5 / 6

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Merging data from multiple Excel files

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...

Data Management

Migrating Website to Cloud - Emmanuel Katto

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

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

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...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Similar topics