verify external data before importing

[MarMo]

Hi there ,

In my small application i'd like to import a .cvs , .xls or .txt file into a
known sheet.

I'd like to verify the file that will be imported before the data is
imported.
for example : headers need to match or number of columns must be 5 , etc

These are the steps to follow :
1) Click a button to import
2) open the file for verification and verify some data with criteria.
3) if verification is correct => import data , else close file and stop
importing.

Can someone help me a little bit with this one? or point me in the right
direction.
Thanks
Marmo

 

[Don Guillett]

Might be easier to have the macro import the file to a page and then look to
see if you want to copy to the main page.

 

[MarMo]

Hi Don ,
I was thinking about this:
Or to open the file before importing or importing it into an "importpage".
Maybe i can use an Msquery file to import from a fixed path/file folder.
ie: C:\DbFolder\xlsfile.xls

I get a rough idea how to accomplish this.
If you or someone else have another idea , i'll be glad to hear it.
Thanks for the reply
MarMo

 

[Don Guillett]

Try expanding on this idea.

goto the url>right click in the table>import to excel>if desired, record a
macro while doing

 

[MarMo]

Don ,
I will try this out.
If I have a sample , i'll post again.
Many thanks
MarMo