Search results

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.

Can try out with this 2 file. Currently defined as text, import as text and first row contain header

I have tried importing it as a text quantity column and number quantity column but both have the same error.

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...