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

Hello Tom,
The simple way is to create a store table with storeid, import the item. You
can import all records, you dont need 600 Tables.
Just need 2 tables.

Can you just upload some sample, we can have a look.

Ayisha


----- Original Message -----
From: "Tom Keatley" <tomk at multiline.com.au>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Thursday, February 19, 2004 12:14 PM
Subject: [AccessD] URGENT HELP importing a very large CSV file (many Fields)


> Hi all....
>
> 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
>
> can anyone help?
>
> Regards
>
> Tom Keatley
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com