Hi everyone I have a set of data using query and I export it with specifications.
Would like to check if I am able to perform the same export step but using Macro function?
Hi everyone, thanks for helping on this issue. I found a temporary solution to import with first row as header unchecked. I am then able to import with the quantity successfully.
Then create a delete query to remove that header row from table.
Hi, I have a text file with 'Quantity' that consist of comma.
I am trying to import it into MS Access as text file. But it always throw 'Type conversion error'.
For the Quantity field on the table i have tried different variation such as text, int, number with standard format but to no avail...