Hi friends
I have a scenario in which I am asked to upload the text file to be uploaded into an access table.
The only problem is when I split the file it doesn't get viewed into the table
The text file format is as follows:
I have splitted the file into number of characters below and trying to upload it into the table with text format
36120047886685555 02 78232253 715522
Please help me with the vba code to view the above string in the table.
Thanks in advance.
I am not sure what this means. Do you only have the four fields and they look like numbers but you want them as text and they have the layout as shown?I have splitted the file into number of characters below
What does this mean. What do you see in the table?the file it doesn't get viewed into the table
Perhaps some more details. Are you able to upload a sample of your text file you wish to have imported to your Access file for testing.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi Alan
I cannot see anything in the table, it is blank. yes i want the numbers as text. can you please help.
Upload your text file for testing. Difficult to diagnose a patient in absentia.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks