Validate Structure from text file with the spec

  • Thread starter Thread starter Dante Huapaya
  • Start date Start date
D

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
 
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
Click to expand...

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
 
Back
Top