Recent content by Ltravis

arnelgp: I have done this and it still gives me the same error

In attempting to run the database I have run into the following error: Run-time error '3011'. The Microsoft Office Access database engine could not find the object 'Sheet1'. Make sure that the object exists and that you spell it's name and path correctly. If 'Sheet1' is not a local object...

From the previous post above continued.... Does anyone know why I am getting null values appended to the fields if no comma exists? Is there a condition I can use if no comma exists to not append the data? This is the select statement I am using: INSERT INTO Results1 ( DCN_Filename...

Please find the requested data linked/attached below... Sample file attached: The Database provided did not allow for my files to be drawn in as expected. I did update all appropriate/relevent field names and table names for the sampled date to reflect properly. I Imported the data into...

I am sorry arnelgp, I can not it is sensitive information. I have tried the CSV approach. There was data lost in this approach and the values where not all seperated properly. I have tried the formula approch seperating the values with Left$, Mid & Right$ but because of the comma being the...

Hello All, This is my first thread post in this forum. I have been scouring the internet to help identfy a resolution to my issue with no results. I am trying to take a file that produces results that are to large for excel to handle and create a reliable export of unique rows. My input...