Hello all,
I am linking an access table to an excel spread sheet. The spread sheet in turns is linked via FTP to a csv file that is on a remote drive and that is continually being updated in real time. The spread sheet data is being refreshed every 10 minutes with new CSV data.
One of the fields in access (unfortunately the field that has the primary key) should be text field. however because sometimes the first 25 or so records in the excel sheet look like numbers the link is establishing the field in the access table as a number. As result when records appear that do not have a numerical value, then the imported field for that record becomes null.
Can someone please suggest a way in which I can force the link to consider this field as a string regardless of the data that appears in it.
Thanks
ron
I am linking an access table to an excel spread sheet. The spread sheet in turns is linked via FTP to a csv file that is on a remote drive and that is continually being updated in real time. The spread sheet data is being refreshed every 10 minutes with new CSV data.
One of the fields in access (unfortunately the field that has the primary key) should be text field. however because sometimes the first 25 or so records in the excel sheet look like numbers the link is establishing the field in the access table as a number. As result when records appear that do not have a numerical value, then the imported field for that record becomes null.
Can someone please suggest a way in which I can force the link to consider this field as a string regardless of the data that appears in it.
Thanks
ron