Erwin Craps - IT Helps
Erwin.Craps at ithelps.be
Thu Feb 19 04:04:17 CST 2004
That in case its a one time shot.... -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Thursday, February 19, 2004 10:40 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] URGENT HELP importing a very large CSV file (manyFields) Hi Tom How are you "playing"? Anyway, you'll need to read the file line by line and break each line up for import. Here's a link to the site of Seth with code to get you started: http://puma.agron.ksu.edu/~sgsax/ Look for "My downloads", then "File I/O in VB": Code snippets demonstrating reading from and writing to plain text files. /gustav > I have a CSV file that I need to get information from and build a > table in Access ....it contains 600 fields and of course I cant > simply import it as it hits the access limit of 255 fields and will > not import the whole file > It is simply an Order for goods with 150 or so records but from 500 > different locations. > so ... > Fields in the CSV file > [Item ] > [itemcode][storeid1][storeid2][storeid3][storeid4][storeid5]etc to 600 > fields > I need to bring those into access and populate a table so.... > [Item ] [itemcode][storeid1] > [Item ] [itemcode][storeid2] > [Item ] [itemcode][storeid3] > [Item ] [itemcode][storeid4] > [Item ] [itemcode][storeid5] > [Item ] [itemcode][storeid6] > etc > using the data contained in [Item ] [itemcode] fields and using the > fieldname from the 500 odd [storeid] fields as my store id. > I have been playing with this for some hours so far and dont seem to > be able to acheive what I need _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com