ScoobyNet.com - Subaru Enthusiast Forum - Getting 150k Records Into MS Access

ScoobyNet.com - Subaru Enthusiast Forum (https://www.scoobynet.com/)

- Computer & Technology Related (https://www.scoobynet.com/computer-and-technology-related-34/)

- - Getting 150k Records Into MS Access (https://www.scoobynet.com/computer-and-technology-related-34/219641-getting-150k-records-into-ms-access.html)

DJ Dunk

13 June 2003 02:30 PM

I have around 150,000 records in a fixed width file that I need to load into MS Access 2000.

Any ideas how to go about it ? It doesn't appear to take a flat text file.

GaryK

13 June 2003 02:42 PM

Dunk,

What happens? Just fired up Access 2000, file get external data->import from file, I just loaded a 50,000 record csv file straight in, no problems!

Gary

DJ Dunk

13 June 2003 02:46 PM

Thanks Gary.

I do File, Get External Data->Import (doesn't say from file on mine).

All I get is the option to open - various dBASE formats, Exchange, Excel or Access.

New to Access and its run over Citrix so I have little control over it :(

DJ Dunk

13 June 2003 02:49 PM

Is it possible that they haven't installed the 'File Import' bit ?

Figment

13 June 2003 02:59 PM

Bit of a pain, but could you run the csv into Excel first?

DJ Dunk

13 June 2003 03:01 PM

Cheers Fig, thats my backup plan if it can't be done an easier way :)

A lot of a pain though as Excel only takes 65k at a time :(

[Edited by DJ Dunk - 6/13/2003 3:02:19 PM]

Andrewza

13 June 2003 05:38 PM

I believe you can install office without installing all the import filters, so yes if you're missing it, my guess is that's what's happened...

All times are GMT +1. The time now is 04:52 AM.