This is the field "Company_Name" from the .csv file I would like to import into MS Access:
Code:
A very long name which I need to split into 1, 2, 3 or 4 different fields depending on the number of characters, because the 1, 2, 3 and 4 fields should be 35, 40, 40, 100 characters long!
What I am looking for is to split (full words) this long "Company Name" into four company fields (Company_Name 1, Company_Name 2, Company_Name 3, Company_Name 4) of lenght (35, 40, 40, 100) respectively when importing the .csv file into ms access in the table "tbl_Revenue"....
Field 1 in table in Access: Company_Name 1 (length = equal or less than 35 characters)
Code:
A very long name which I need to
Field 2 in table in Access: Company_Name 2 (length = equal or less than 40 characters)
Code:
split into 1, 2, 3 or 4 different fields
Field 3 in table in Access: Company_Name 3 (length = equal or less than 40 characters)
Code:
depending on the number of characters,
Field 4 in table in Access: Company_Name 4 (length = equal or less than 100 charachters)
Code:
because the 1, 2, 3 and 4 fields should be 35, 40, 40, 100 characters long!
Some function or procedure which could help me to do this will be highly appreciated! Even tips!