473,322 Members | 1,734 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Exporting, Emaling and importing tables in Access

68
I have a database that my users populate over a wide area. this database is not networked as it is not possible to do so given finance and location of users. I however want to have all the information in one data repository. To achieve this I am attempting to have a table of updated data exported, emailed central office, then imported to the main database and appended to the existing records. I want to accomplish the export and email function with just one click of a button then have the import function executed with one click also.

Has any one have had to perform this task befor or have insights on how to go about accomplishing these goals.

Thanks for the help as always.
Nov 16 '09 #1
5 1566
NeoPa
32,556 Expert Mod 16PB
What I did in a similar situation was to create a BackEnd database that the FrontEnds in all places link to. The remote station does their stuff then emails (a copy of the BackEnd to the central station where it is put in a specific place, where the cenntral FrontEnd can access it. Emailing in code is a whole nother thing entirely of course.
Nov 16 '09 #2
ADezii
8,834 Expert 8TB
@KingKen
You may want to look into Database Replication, but I warn you that it definately is not for the faint of heart!
Nov 16 '09 #3
KingKen
68
Ok guys you have done a great job at scaring me... Now how do we move forward? Where can I find info on Database Replication? how about exporting the data to a spread sheet then emailing that as an attachment then importing it and appending the data to the table.
Nov 17 '09 #4
ADezii
8,834 Expert 8TB
@KingKen
I don't know your specific Access Version, so simply do a search on Access Database Replication, and you'll have more references than you can handle.
Nov 17 '09 #5
NeoPa
32,556 Expert Mod 16PB
@KingKen
That could work, but I'd advise a text format rather than Excel if that's how you're minded. Excel is inherently dodgy for that purpose as it loses the type of much of the data.
Nov 17 '09 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: sridevi | last post by:
Hello How to export data from ms-access database to excel worksheet using ASP. mainly i need to export data to multiple worksheets. it is very urgent to us. i have a sample code which works...
5
by: dixie | last post by:
If I sent a user an empty database container - dB with no tables and I needed them to import their tables into it and one of their tables was a hidden table with the prefix Usys, is there any way...
2
by: deko | last post by:
I use a complied query to export to Excel like this: SELECT * INTO . FROM tblExcelData; But I have a situation where I need to export several tables into the same worksheet. The idea is to...
2
by: Slawek Piascik | last post by:
I've developed application in Access XP that has FE, BE configuration (BE over 50 tables). New version of the program has similar but different BE structure. Is there a way to export data from...
11
by: MLH | last post by:
Anyone ever experiement importing WAB data directly into A97? Would lke a chance to look at any work done in this arena.
2
by: Snozz | last post by:
The short of it: If you needed to import a CSV file of a certain structure on a regular basis(say 32 csv files, each to one a table in 32 databases), what would be your first instinct on how to...
0
by: Mike Collins | last post by:
I am trying to export data from multiple tables in SQL Server to an XML file so I can then import it to another database. It seems to be working fine for exporting, but I am having trouble...
1
by: Jason.A.Oliver | last post by:
Hi everyone, Quick question. I'm very much a beginner with Access so I'm sorry if there's an easy way that I missed. I have several fairly large tables that I am trying to export from Access...
1
by: John Overton | last post by:
I have a new requirement to Import and Export Excel tables into and out of Access 2003. The Excel tables are located on a remote server but I know the path to the Excel Files. Can you please help...
2
by: jjwiet | last post by:
Hello, I use access 2003 and attempting to export/copy records between two access databases (almost identical) with multiple tables (both databases having the same relations between the tables)....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.