|
More site info...
Discussions in... - www.microsoft.com/communities/newsgroups... | Site profile
|
|
Site profile page for http://www.microsoft.com/communities/newsgroups....
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.microsoft.com/communities/newsgroups....
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://www.microsoft.com/communities/newsgroups... is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a site's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity table on Discussions in microsoft.public.access.externaldata:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
33
|
111
|
270
|
|
Post:
|
43
|
157
|
423
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for Discussions in microsoft.public.access.externaldata (http://www.microsoft.com/communities/newsgroups...)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
Discussions in microsoft.public.access.externaldata posting activity graph:
|
|
http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.externaldata Alexa graph:
|
Top authors on Discussions in microsoft.public.access.externaldata during last week:
user's latest post:
Align Right certain fields of a...
Published (2009-11-24 10:03:00)
Since you are using fixed width, use the String function to add leading spaces. For example if a LastName field is a maximum of 20 characters, something like this in a query: TheLastName: String(20-Len([LastName])," ") & [LastName]
user's latest post:
Align Right certain fields of a...
Published (2009-11-24 10:25:00)
Use calculated fields to be the right-aligned columns. Here's an example of how to write the calculated fields: FieldName_Calc: Right(Space(SizeOfFixedWidthColumn) & [RealFieldName], SizeOfFixedWidthColumn) So, if the width/size of the fixed width column were 20: FieldName_Calc: Right(Space(20) & [RealFieldName], 20)
user's latest post:
Re: we suse com stai in...
Published (2009-11-18 11:15:00)
"ELENA PICCOL.O" <prova@exampl.com> ha scritto nel messaggio news:... >com iam .
user's latest post:
ACC2007: numeric fields...
Published (2009-11-18 12:20:00)
Hi, I'm back. Just to say that my problem is solved. I uninstall the Access 2007 Developer Extensions (I don't know what was wrong with it). After that, all is working as supposed. Antonio "d_nu_b" wrote: > Hi, > > > I'm using Access 2007. When I import a Dbase III file (Ribbon/Open/dBase > III), the file imports with no errors, but float numeric dBase fields shows...
user's latest post:
Re: Export delimited text in...
Published (2009-11-19 10:30:00)
"io" <someone> wrote in message news:... > > "io" <someone> wrote in message news:... >> >> "Kenny G" <KennyG@discussions.microsoft.com> wrote in message >> news:5D373F84-50C1-4933-9EEF-4DF5C32C58D9@microsoft.com... >>> Ms Gina, >>>...
user's latest post:
Microsoft Access in...
Published (2009-11-19 05:12:00)
Hi Jerry, Thanks for getting back to me It is any spreadsheet they try to import to Access. They import their spreadsheet manually ever time. This is only happening to 4 users in a corporate office. I have try reinstalling several times with no luck. If the users goes to another computer they are able to import the spreadsheets with no problem. It is just their own PC that are having the problem. This just started happening about a...
user's latest post:
Importing FoxPro 2.6 DBF Into...
Published (2009-11-21 08:03:00)
Problem solved..... DoCmd.TransferDatabase acImport, "ODBC Database", "ODBC;DSN=Visual FoxPro Tables;SourceType=DBF;SourceDB=z:\temp\;Collate=Machine", acTable, "sampleus", "Importzzz" "Redelman" wrote: > All - I am looking for a little help. As part of a larger application, I > need to IMPORT (not link) a FoxPro 2.6 DBF into a...
user's latest post:
ȫеľӪÀíÄî in...
Published (2009-11-24 19:20:00)
?ɭ?˾?ҵΪ?ѽ?ר?ž?Ӫ?ֲ?ҵ?ý?ճ?Ʒ?˾ƾ?ȫ?µľ?Ӫ??õĹ?ģʽ?ǵ?г?ҵ?Ͳ?ڿ?ٷ?չ?ģ?γ?һ?Ӱ?֪?ȡ?£?Ͽͻ?֧?֡?Ϊ?˸?õ?Ϊ?ͻ?ṩ?ݵķ?Ϊ?ͻ?ÿ?ÿ?Ҫ?ṩ?ƴ𰸡?ư? ?Ƽ?µļ?˵IJ?Ʒ?ټ? ?Ʒ?ͻ?ʹ?ù?⡣ ?ϵ?绰?13225699316 .
user's latest post:
How to link single excel...
Published (2009-11-18 12:29:00)
Is it possible to link a single spreadsheet to multiple tables. I have a excel spreadsheet that contains with 22 columns of information. I would like to link the spreadsheet to multiple (different tables), so that it will update the tables everytime I update the spreadsheet. If this is possible, instruction on how to will be greatly appreciated
user's latest post:
Access Database w/ Excel Import...
Published (2009-11-18 11:30:00)
I have a DB2 Database that is used to store certain data related to work tickets. However, there is additional information that we need to track that is not stored in the DB2 Database. The DB2 Database is used by numerous divisions so we are unable to add field to accomodate all that we need. I can query the DB2 tables to pull the information that I need and export that into an Excel spreadsheet. I can then import that data into MS...
|
|
|
Top 10 active forums on Discussions in microsoft.public.access.externaldata during last week:
|
|
Top 10 forums on Discussions in microsoft.public.access.externaldata:
|
|
|
|
Latest active threads on Discussions in microsoft.public.access.externaldata:
Started 2 days, 17 hours ago (2009-11-26 12:50:00)
by Sylvain Lafontaine
When you make a reference to another post, you should give it reference so
that people can take a look at it and see what you are doing or try to
follow.
In your case, when you see that you accentuated letters have been replaced
by a combination of two letters, the first one beeing Ã, you must suspect
that your file is in ...
Started 4 days, 19 hours ago (2009-11-24 10:03:00)
by Jerry Whittle
Since you are using fixed width, use the String function to add leading
spaces. For example if a LastName field is a maximum of 20 characters,
something like this in a query:
TheLastName: String(20-Len([LastName])," ") & [LastName]
Started 4 days, 19 hours ago (2009-11-24 10:25:00)
by Ken Snell
DoCmd.TransferSpreadsheet acImport, , "Temp", sDir & "Jobs_Per_Prop", True,
"sheetb$"
Started 4 days, 19 hours ago (2009-11-24 09:56:00)
by Jerry Whittle
If you are importing into an existing table, add a date field to that table
and make the default value Now(). That will show the date and time that new
records were added to the table.
Started 5 days, 14 hours ago (2009-11-23 15:20:00)
by Douglas J. Steele
You sure you named your saved export spec PIExport? Might you have called it
something else?
|
|
Hot threads for last week on Discussions in microsoft.public.access.externaldata:
Started 4 days, 19 hours ago (2009-11-24 10:03:00)
by Jerry Whittle
Since you are using fixed width, use the String function to add leading
spaces. For example if a LastName field is a maximum of 20 characters,
something like this in a query:
TheLastName: String(20-Len([LastName])," ") & [LastName]
Started 1 week ago (2009-11-21 08:03:00)
by Redelman
Problem solved.....
DoCmd.TransferDatabase acImport, "ODBC Database", "ODBC;DSN=Visual FoxPro
Tables;SourceType=DBF;SourceDB=z:\temp\;Collate= Machine", acTable,
"sampleus", "Importzzz"
"Redelman" wrote:
> All - I am looking for a little help. As part of a larger application, I
> need ...
Started 5 days, 14 hours ago (2009-11-23 15:20:00)
by Douglas J. Steele
You sure you named your saved export spec PIExport? Might you have called it
something else?
Started 4 days, 19 hours ago (2009-11-24 10:25:00)
by Ken Snell
DoCmd.TransferSpreadsheet acImport, , "Temp", sDir & "Jobs_Per_Prop", True,
"sheetb$"
Started 4 days, 19 hours ago (2009-11-24 09:56:00)
by Jerry Whittle
If you are importing into an existing table, add a date field to that table
and make the default value Now(). That will show the date and time that new
records were added to the table.
Started 2 days, 17 hours ago (2009-11-26 12:50:00)
by Sylvain Lafontaine
When you make a reference to another post, you should give it reference so
that people can take a look at it and see what you are doing or try to
follow.
In your case, when you see that you accentuated letters have been replaced
by a combination of two letters, the first one beeing Ã, you must suspect
that your file is in ...
Started 1 week, 1 day ago (2009-11-20 09:30:00)
by Jeff Boyce
Not sure what you mean by "link spreadsheet to table"...
In Access, you can link to a spreadsheet ... and Access treats that link as
if it were a table.
Why would you want/need to link to the same spreadsheet multiple times?
What problem are you trying to solve with this approach?
More info, please...
...
Started 1 week, 3 days ago (2009-11-18 13:25:00)
by Jerry Whittle
We need a lot more info to even take a WAG.
Is it the same Excel spreadsheet or all spreadsheets?
What happens when someone else tries to import the spreadsheet?
Exactly how are they doing the import: Macro, code, manually.
And the big question: What version of Access?
|
|
Size: 1,171 bytes
