Recently, my boss had asked me to develop a program to transfer

records from Excel 2000 files to Access 2000 database.

Would it be easier to use Visual Basic as an interface

program to capture records from Excel and then upload it

to Access database than develop the program in Access?



In addition to this, I also need to develop another interface

to enter records manually (some records come in hard copy

format), generate reports and an inquiry interface for

user to search for a particular record. Kindly please advice

me as my knowledge in Visual Basic and Access is limited.

I'd appreciate it if someone has a better idea to share

with me.



Please let me know too if someone knows where i can get 

sample coding to capture records from Excel 2000 using

VB and upload to Access from VB. Thanks in advance.



Regards,

Vincent.

I probably wouldn't even use VB.  I would just import the information into

Access and use VB or Access forms as the front-end.



Another suggestion just import the file each time it's update in Access with

the Transfer Spreadsheet Method of the docmd object.



I hope this help but if it doesn't send another e-mail out I have a lot

experience with importing different file types into Access



Robert L. Rogers

Rexel Branch Electric

Application Developer

xxx-xxx-xxxx

 



-----Original Message-----

From: vincentfvy@y... [mailto:vincentfvy@y...]

Sent: Wednesday, August 08, 2001 12:57 PM

To: Access

Subject: [access] VB, Access 2000 and Excel 2000





Recently, my boss had asked me to develop a program to transfer

records from Excel 2000 files to Access 2000 database.

Would it be easier to use Visual Basic as an interface

program to capture records from Excel and then upload it

to Access database than develop the program in Access?



In addition to this, I also need to develop another interface

to enter records manually (some records come in hard copy

format), generate reports and an inquiry interface for

user to search for a particular record. Kindly please advice

me as my knowledge in Visual Basic and Access is limited.

I'd appreciate it if someone has a better idea to share

with me.



Please let me know too if someone knows where i can get 

sample coding to capture records from Excel 2000 using

VB and upload to Access from VB. Thanks in advance.



Regards,

Vincent.