Getting 150k Records Into MS Access
13 June 2003, 02:30 PM
#1
Moderator
Thread Starter
iTrader: (5)
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes
on
0 Posts
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.
Any ideas how to go about it ? It doesn't appear to take a flat text file.
13 June 2003, 02:42 PM
#2
Scooby Regular
Join Date: Sep 1999
Location: Bedfordshire
Posts: 4,037
Likes: 0
Received 0 Likes
on
0 Posts
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
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
13 June 2003, 02:46 PM
#3
Moderator
Thread Starter
iTrader: (5)
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes
on
0 Posts
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
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
13 June 2003, 03:01 PM
#6
Moderator
Thread Starter
iTrader: (5)
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes
on
0 Posts
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]
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]
Thread
Thread Starter
Forum
Replies
Last Post