Custom import macro

[sliminconcoova]

Hi peeps. I have this software where it exports computer specs in .csv format. only issue is that what should be headers are in the column (computer name, domain etc...)

I was hoping you guys could help me create a macro that would
1. select the .csv i want to import from
2. find specific words in the column
3. import the data associated in the next column


4. repeat for each specific bits of data

I would do a normal import but its a case of putting column stuff into a row. any ideas? give me a clue and i can do the rest lol.

I want this to be on a button command so an onClick() sort of thing then prompts to open file blah blah blah,,.,.,.

Hope your all well btw

[HiTechCoach]

Will you post a sample of the CSV file?

[sliminconcoova]

here tis...a sample

[HiTechCoach]

Thanks for posting the sample. I will download and take a look.

[HiTechCoach]

Would you mind sharing what software is generating this data?

[sliminconcoova]

it is a free inventory auditor

[HiTechCoach]

Thanks.
What is the name of the software?
can you post a link to the site/download?

[sliminconcoova]

its called winaudit.exe

[HiTechCoach]

Thanks. Is this it CLICK HERE?

The file you posted looks to be like a standard CSV file. The first row is the column headers.

I assume that you generate this file for a single PC at a time. All the rows will pertain to a single PC. Each row is a different item on the PC.

I assume that you want to import the data into the same normalized fashion. Is this correct?

[sliminconcoova]

Thanks. Is this it CLICK HERE?

The file you posted looks to be like a standard CSV file. The first row is the column headers.

I assume that you generate this file for a single PC at a time. All the rows will pertain to a single PC. Each row is a different item on the PC.

I assume that you want to import the data into the same normalized fashion. Is this correct?

Yes that is correct. I dont however want to do it based on the headers. it has to be filtered by the content of the corresponding column. Does that make sense?

[weekend00]

you can try to write codes to read the .csv line by line, find the column you need and then add to a table.

[HiTechCoach]

Yes that is correct. I dont however want to do it based on the headers. it has to be filtered by the content of the corresponding column. Does that make sense?

No, that does not make sense.

The columns header tell you the structure of the file.

Is is possible to post a sample of you database that you want to import this into. Maybe if I can see what you are doing, it will make a lot more sense.

Otherwise, will you be more specific about what you need to do with this data?

[sliminconcoova]

No, that does not make sense.

The columns header tell you the structure of the file.

Is is possible to post a sample of you database that you want to import this into. Maybe if I can see what you are doing, it will make a lot more sense.

Otherwise, will you be more specific about what you need to do with this data?

Table in database will have computerid, harddrive size, processor etc for the headers. Each row within the csv are technicly acting as an identifier for this code I want to find what is in the cell to the right of "processor" is injected into the cell with Id "processor"

[sliminconcoova]

you can try to write codes to read the .csv line by line, find the column you need and then add to a table.

thanks, thats a great help! if only i knew how to write the code...

[ssanfu]

thanks, thats a great help! if only i knew how to write the code...

Attached is a text file that has the basic code () to import a text or csv file. You will also need the code from The Access Web at:

http://www.mvps.org/access/api/api0001.htm


Copy the code and paste it into a standard module. I named my module "modOpenSaveFile".

You will have to figure out how to parse the input string, store the value in a variable, when to know you have reached the end of the data for a specific computer, how to create the SQL append statement. If you are going to update a record in a table, you will need to find the record then update the data.

HTH
------
Steve
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)