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

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.
--
Don Guillett
SalesAid Software

"MarMo" wrote in message
...
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

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" wrote in message
...

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.
--
Don Guillett
SalesAid Software

"MarMo" wrote in message
...
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

Try expanding on this idea.

goto the urlright click in the tableimport to excelif desired, record a
macro while doing

--
Don Guillett
SalesAid Software

"MarMo" wrote in message
...
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" wrote in message
...

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.
--
Don Guillett
SalesAid Software

"MarMo" wrote in message
...
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 ,
I will try this out.
If I have a sample , i'll post again.
Many thanks
MarMo

"Don Guillett" wrote in message
...
Try expanding on this idea.

goto the urlright click in the tableimport to excelif desired, record a
macro while doing

--
Don Guillett
SalesAid Software

"MarMo" wrote in message
...
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" wrote in message
...

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.
--
Don Guillett
SalesAid Software

"MarMo" wrote in message
...
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