VB question

omg its nlm

lvl 17 Hax
Joined
10 Jan 2004
Messages
1,829
I am trying to sort this data in execl using vb. As you can see it is in one row. it was imported from a txt file. anyone know any code that can sort that out for me. Basicly want after the comma and then have that copied and put into another sheet.

Thanks
 

Attachments

  • untitled.gif
    untitled.gif
    12.7 KB · Views: 102

jkipk

OSNN Addict
Joined
17 Dec 2002
Messages
121
Excel can import comma separated values files. Save or copy the text file as FILENAME.csv and then open it in excel as a text file. It should open with a column for each comma. Shouldn't need any coding unless I'm misunderstanding your question.

Is this what you needed to do?

kip
 

omg its nlm

lvl 17 Hax
Joined
10 Jan 2004
Messages
1,829
wow that excatly what I needed. Never knew you could do that. Basicly I am putting it into a database for invertory. I thinkn I can handle it from here. thanks again!
 

omg its nlm

lvl 17 Hax
Joined
10 Jan 2004
Messages
1,829
One final question. I have it all seprated and imported into Access. Is there an easy way to sort those 10 feilds I requested on the report, because they keep on repeating. Just wondering if there is a way to idenifty that. I dont want to enter all of them in by hand. We have over 300 puters.
 

jkipk

OSNN Addict
Joined
17 Dec 2002
Messages
121
Happy to help, but I'm not quite sure I understand how you are going about setting up your database. How familiar are you with Access? You should be setting up a table with the first column as the field name, and then the second column as records 1-300, right?

PS I'm not much of a database guru, just trying to learn myself. Glad to be of some small service, though.

kip
 

Members online

No members online now.

Latest profile posts

hello peeps... is been some time since i last came here.
Electronic Punk wrote on Sazar's profile.
Rest in peace my friend, been trying to find you and finally did in the worst way imaginable.
Terrahertz wrote on Electronic Punk's profile.
Yo fellas!
Electronic Punk wrote on Sazar's profile.
Where are you buddy?
Perris Calderon wrote on Electronic Punk's profile.
Hey EP! All good with me, applying for Microsoft MVP right now, should have done this a while ago.

Notifications don't work, I only found your response by coming back to hunt up some threads, if you want, give me your email address so we can keep in touch easier!

Forum statistics

Threads
61,997
Messages
673,418
Members
5,591
Latest member
nodee