Importing from WorkSheet ms-Excel97

[x-digital]

I'm decided. After to read what do you say about split DB, i'd like work so.

But i have problem.

I'm working back-end and front-end. The data come from worksheet of MSExcel
importing by Access.

But I don't know how can I to make a code vba to Import of Data from
Worksheet of MS-Excel showing progress bar and making the tables on access.

thx

 

[Arvin Meyer [MVP]]

You treat the linked tables in Access exactly the same as if they were
local. You can also link an Excel worksheet to the front-end (as long as
it's configured with only columns, like a table. The first eow can be the
field names)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[x-digital]

No, i don't want to link the worksheet of excel to access's tables.

Will not work for me.

The file of Excel, it will be portable.

The user fill with the data on excel's file, copy on disk and give me. The
importation will be done of this disk.

When the importation to finish, i'll have clean the disk and i'll have to
write the clean worksheet on this same disk.

Do you understand me?
Sorry by my bad english.

 

[x-digital]

No, i don't want to link the worksheet of excel to access's tables.

Will not work for me.

The file of Excel, it will be portable.

The user fill with the data on excel's file, copy on disk and give me. The
importation will be done of this disk.

When the importation to finish, i'll have clean the disk and i'll have to
write the clean worksheet on this same disk.

Do you understand me?
Sorry by my bad english.