473,325 Members | 2,805 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

VB with Text File

Hello Sir,

By using VB 6 can we conver our text file data which is having in CSV format into MS-ACCESS Data Base or Oracle.

If it is possible please give me a simple example with code.

Thanking you.

Jayachandra.C
Jul 26 '07 #1
9 1659
Killer42
8,435 Expert 8TB
By using VB 6 can we conver our text file data which is having in CSV format into MS-ACCESS Data Base or Oracle.

If it is possible please give me a simple example with code.
You can, but it's probably simplest to use the database's Import function to read CSV format.

By the way, what version of VB are you using?
Jul 26 '07 #2
Thank you sir,

Here I am using VB 6 and Access 2003.

Please give me one example on that program.

I am awaiting for ur reply.

Jayachandra
Jul 28 '07 #3
Killer42
8,435 Expert 8TB
Thank you sir,

Here I am using VB 6 and Access 2003.

Please give me one example on that program.
I can do so tomorrow, when I'm back at work. I have some VB code there which does an import to a database.
Jul 29 '07 #4
Killer42
8,435 Expert 8TB
I can do so tomorrow, when I'm back at work. I have some VB code there which does an import to a database.
Sorry, I forgot. The import part of my processing is handled from VBA, which in this respect is probably very different to VB6. Here's what it does...

Expand|Select|Wrap|Line Numbers
  1. DoCmd.TransferText acImportDelim, "MySpecName", "MyTempTable", ImportFrom, True
So this may not be any help.

I'd suggest you ask in the Access forum, as there's more Access experience there. First though, if you haven't already, do some searching on the topics of importing, databases, VB and DoCmd. There's a good chance we have already covered this in the past.
Jul 30 '07 #5
Thank you sir,

thank you for ur immediate response I will try.
Jul 31 '07 #6
One more information I want sir,

Can we hide any file by using VB6 or VBA. IF POSSIBLE A SMALL EXAMPLE.

PLEASE....

THANK YOU
Jul 31 '07 #7
Killer42
8,435 Expert 8TB
One more information I want sir,
Can we hide any file by using VB6 or VBA. IF POSSIBLE A SMALL EXAMPLE.
PLEASE....
When you say "hide" a file, do you just mean turning on the Hidden attribute?

Add "Microsoft Scripting Runtime" in your projects references, then try this...
Expand|Select|Wrap|Line Numbers
  1. Dim fso As New FileSystemObject, f As File
  2. Set f = fso.GetFile("C:\Temp.Txt")
  3. f.Attributes = f.Attributes + Hidden
  4. Set f = Nothing
Jul 31 '07 #8
[thank you sir, I will try for this.

bye
Aug 3 '07 #9
Killer42
8,435 Expert 8TB
[thank you sir, I will try for this.
Great! Let us know how it works out.
Aug 4 '07 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

22
by: Ling Lee | last post by:
Hi all. I'm trying to write a program that: 1) Ask me what file I want to count number of lines in, and then counts the lines and writes the answear out. 2) I made the first part like this: ...
1
by: Rigga | last post by:
Hi, I am new to Python and need to parse a text file and cut parts out i.e. say the text file contained 5 rows of text: line 1 of the text file line 2 of the text file line 3 of the text...
27
by: Eric | last post by:
Assume that disk space is not an issue (the files will be small < 5k in general for the purpose of storing preferences) Assume that transportation to another OS may never occur. Are there...
16
by: thenightfly | last post by:
Ok, I know all about how binary numbers translate into text characters. My question is what exactly IS a text character? Is it a bitmap?
7
by: Chris | last post by:
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...
3
by: bbepristis | last post by:
Hey all I have this code that reads from one text file writes to another unless im on a certian line then it writes the new data however it only seems to do about 40 lines then quits and I cant...
1
by: Osoccer | last post by:
...to a different folder and in the relocated file concatenates all of the lines in one long string with a space between each line element. Here is a fuller statement of the problem: I need a...
10
by: bluemountain | last post by:
Hi there, Iam new to python forms and programming too I had a text file where i need to extract few words of data from the header(which is of 3 lines) and search for the keyword TEXT1, TEXT2,...
0
Debadatta Mishra
by: Debadatta Mishra | last post by:
Introduction In this article I will provide you an approach to manipulate an image file. This article gives you an insight into some tricks in java so that you can conceal sensitive information...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.