Import data in text datatype

[gundecharahul]

Hi,

I have a csv file which i need to import into MS-Access as a table.
I am doing this by using transfertext method.
Now the problem is that i want all the data in CSV to be transfered as text data type in MS-Access table.
I know we can create /update the specification file in import/export wizard under Advance option, but i don't want to do any manual task..my code should take care of this, also my specifications of file to be imported, will change everytime.

One thing i could thought was that i can create one table with all the columns in it with text data type and number of columns in table would also match with csv file and then use transfertext method.

But the above method doesnot work, intersting thing is that when i create table and imort the data manually then all the data will be transferd as text datatype but if i do this by transfertext it gives me ImportError if data in one of the column is mixed (number and text) .

I would really appreciate if someone could help me in resolving above problem.

Thanks,
Rahul

 

[FoFa]

You could either create a specification for each type you want to import, specifying text.
You could use a positional import and import the whole row into a single text column then use VBA to split the elements out and put them in a table.
You could use VBA to read the file yourself and parse it then handle each individually.

As some options.

 

[gundecharahul]

Thanks a lot for your quick reply and i apologize for my late reply.
I found the solution with your tips.

Thanks again.