verify external data before importing
 

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

verify external data before importing
 

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

verify external data before importing
 

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

verify external data before importing
 

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

verify external data before importing
 

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