csv files

village idiot · Post by **village idiot** » Tue Oct 07, 2008 10:33 pm

does anyone have a program i can use to access a csv file?
i have a pricelist from one of our suppliers on excel that it tells you o convert to a csv file for access by an accounts program
i just need something i can input a part number & number required & it will show list price, discount, nett price & total & if possible i can add in our own part number where possible
if neccessary i can email the excel file

lockie · Post by **lockie** » Tue Oct 07, 2008 10:39 pm

Cant you open it in excel ?

village idiot · Post by **village idiot** » Wed Oct 08, 2008 6:29 am

i can open in excel, it's over 100 pages worth if printed
i just wondered if there was something i could use where all i needed to do was type in the part number & quantity required & it would do the rest
instead of looking up the catalogue, finding the part & list price, then getting a sheet which tells you what percentage discount you get so you can work out the nett price

kenjewell · Post by **kenjewell** » Wed Oct 08, 2008 10:01 am

village idiot wrote: i just wondered if there was something i could use where all i needed to do was type in the part number & quantity required & it would do the rest
instead of looking up the catalogue

You could import the file into a database such as MS access, then create a simple query to output your required data.

The calculations for working out net, discount, VAT and gross pricing can also be done real time within MS access.

Hoovie · Post by **Hoovie** » Wed Oct 08, 2008 10:22 am

getting overcomplicated I would say.

VI is just looking (I think) for a way to type in a Part number and show the line of data in the file for that part - simple bit of Excel formula will be that

murraymint · Post by **murraymint** » Wed Oct 08, 2008 7:55 pm

I would say the Ken has got it right, there is no easy way to do this unless you use somthing like Access.

Hoovie · Post by **Hoovie** » Wed Oct 08, 2008 8:00 pm

Sorry for the language, but only one word in reply.... B*llocks

VIs data is provided in a flat file, and how he has described what he wants, Excel (which is a flatfile database application) is perfect for it.

Hoovie · Post by **Hoovie** » Wed Oct 08, 2008 8:45 pm

VI - sent you file, but from diff email (my gmail account kept saying server error

)

village idiot · Post by **village idiot** » Wed Oct 08, 2008 9:04 pm

looks good hoovie

will send an email as i could do with a couple of tweeks

kenjewell · Post by **kenjewell** » Wed Oct 08, 2008 10:20 pm

Hoovie wrote:Sorry for the language, but only one word in reply.... B*llocks

VIs data is provided in a flat file, and how he has described what he wants, Excel (which is a flatfile database application) is perfect for it.

True Hoovie, this will work equally well, however the entire file has to be loaded into memory if using Excel which is fine but would slow down if the file got too large. On saying that it would proberbly suit VI's application ok.

I once developed a SQL database with held over 1.4 million entries of world wide tracking codes for shipping containers, the query averages 0.3 seconds to find any entry. It's still being used to this day

Hoovie · Post by **Hoovie** » Wed Oct 08, 2008 10:33 pm

if you have a database over a certain size, then you do need to start moving into RDMS type products. if a csv file can be loaded into Excel, then it is probably less then 65,535 lines long and is still fair game for flatfile use, I would say (Excel 2007 has removed that limitation and I dread to think how slow that could get if misused

)

The reason I said Excel would do this was that I have had to use Excel to combine literally 1,000's of 10-year costing models into a single Excel workbook as Excel was the standard data tool (rightly or wrongly) so had to work out best way to manage a high volume of data in a less-the-ideal tool, and knew which formulae would do the trick

VI's Excel search is - to the user - instant

Good to have you on the Forum, Ken - always good to swap ideas and info

village idiot · Post by **village idiot** » Thu Oct 09, 2008 7:40 pm

well the file got used today & works a treat

saves a lot of time, next stop is tidying up SXe, when the database was swapped over from Opera it created a few anomolies