[AccessD] URGENT HELP importing a very large CSV file (manyFields)

Erwin Craps - IT Helps Erwin.Craps at ithelps.be
Thu Feb 19 04:03:54 CST 2004


You could open the file in Excel and split fields in multiple files
keeping the UID in each excel files.
Erwin
-----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



More information about the AccessD mailing list