I have a very large tab delimited file (94mb) that I would like to import into MS Access (I've tried with the 2k version but have 2002 on another PC if this makes any difference). The tab file has 24,000 records and 1300 variables (fields). Access seems to have a limited on the number of fields of 255.
I don't actually need all the variables - just a subset of around 20 - but in the import wizard it just won't show anything past the 255th variable for me to be able to select that and hide others.
Can anyone help with a workaround please?
Many thanks,
Rob