How to Import or link CSV with more than 255 columns in ACCESS?

Stoorm

New Member
Joined
Jan 5, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Hello, I have a .csv with more than 255 columns (395 exactly), I only need 3 columns but I cannot manipulate the source file manually, that is, I cannot divide it in two.
The columns are: 131, 208 and 282

I have tried to do it by wizard but Access won't let me do it because it has more than 255 columns.
I have tried a thousand ways with vba but have not been successful.

Is there a way to do it with vba?
 

jackd

Well-known Member
Joined
Oct 19, 2006
Messages
1,295
Office Version
  1. 365
xenou,

I was concerned with >255 columns, not the rows. My thought was that the file was not normalized. So, by reading as a textstream and outputting appropriate data into proper structures.
Just my $.02
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,764
Office Version
  1. 2019
Platform
  1. Windows
That makes sense to me actually. I think it should be possible as well. Normally when you have difficulty reading as a textstream and outputting data, it is either because of a very large amount of data or because of inconsistencies in the data (or both) ... so looking for clues was all.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,783
Messages
5,574,239
Members
412,579
Latest member
ffbaker632
Top