Validate Structure from text file with the spec

[Dante Huapaya]

Hi Everybody,

I have importing a text file (.csv) with specification on my database, how
to make to validate (with VBA) the importation if the text file does not
correspond to the parameters of my specification?
Thank you for your assistance

Carlos Dante

 

[banem2]

Hi Everybody,

I have importing a text file (.csv) with specification on my database, how
to make to validate (with VBA) the importation if the text file does not
correspond to the parameters of my specification?
Thank you for your assistance

Carlos Dante

You can query CSV file with:

SELECT * FROM [TEXT;DATABASE=C:\].filename.csv;

(adjust the path and file name) and make validation before populating
table.

Or - you can import data into temporary table and delete records out
of validation rule(s) before moving them into data table.

Regards,
Branislav Mihaljev
Microsoft Access MVP