Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

microsoft.public.access.externaldata | Forum profile

Forum profile page for microsoft.public.access.externaldata on http://www.microsoft.com/communities/newsgroups.... This report page is the aggregated overview from a single forum: microsoft.public.access.externaldata, located on the Message Board at http://www.microsoft.com/communities/newsgroups.... This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional forum profile information for "microsoft.public.access.externaldata" on the Message Board at http://www.microsoft.com/communities/newsgroups... is also shown in the following ways:

1) Latest Active Threads
2) 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 forum's popularity and/or exact posting volumes at any given reporting period.

Site: Discussions in microsoft.public.access.externaldata - microsoft.public.access.externaldata (site profile, domain info microsoft.com)
Title: microsoft.public.access.externaldata
Url: http://www.microsoft.com/communities/newsgroups...
Users activity: 16 post per thread
Forum activity: 33 active threads during last week
 

Posting activity on microsoft.public.access.externaldata:

  Week Month 3 Months
Threads: 33 111 270
Post: 43 157 423
 

microsoft.public.access.externaldata Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
Jerry Whittle
4
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]
Ken Snell
3
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)
ELENA PICCOL.O
2
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 .  
d_nu_b
2
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...
io
2
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, >>>...
qwerty
2
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...
Redelman
2
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...
linjiji
2
user's latest post:
ȫеľ­ÓªÀíÄî in...
Published (2009-11-24 19:20:00)
  ?ɭ?˾?ҵΪ?ѽ?ר?ž?Ӫ?ֲ?ҵ?ý?ճ?Ʒ?˾ƾ?ȫ?µľ?Ӫ??õĹ?ģʽ?ǵ?г?ҵ?Ͳ?ڿ?ٷ?չ?ģ?γ?һ?Ӱ?֪?ȡ?£?Ͽͻ?֧?֡?Ϊ?˸?õ?Ϊ?ͻ?ṩ?ݵķ?Ϊ?ͻ?ÿ?ÿ?Ҫ?ṩ?ƴ𰸡?ư? ?Ƽ?µļ?˵IJ?Ʒ?ټ? ?Ʒ?ͻ?ʹ?ù?⡣ ?ϵ?绰?13225699316 .  
tmdrake
1
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
MMC
1
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...
 

Latest active threads on microsoft.public.access.externaldata::

Discussions in microsoft.public.access.externaldata
Started 3 days, 9 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 ...
Thread:  Show this thread (2 posts)   Thread info: Trouble importing foreign language accents into Access 2003 in
microsoft.public.access.externaldata Size: 1,171 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Trouble importing foreign language accents into Access 2003 in
microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
Discussions in microsoft.public.access.externaldata
Started 5 days, 12 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]
Thread:  Show this thread (3 posts)   Thread info: Align Right certain fields of a query when exporting as fixed width txt
file in microsoft.public.access.externaldata Size: 485 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Align Right certain fields of a query when exporting as fixed width txt
file in microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
Discussions in microsoft.public.access.externaldata
Started 5 days, 11 hours ago (2009-11-24 10:25:00)  by Ken Snell
DoCmd.TransferSpreadsheet acImport, , "Temp", sDir & "Jobs_Per_Prop", True, "sheetb$"
Thread:  Show this thread (2 posts)   Thread info: Possible to import a specific sheets data from excel into access? in
microsoft.public.access.externaldata Size: 335 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Possible to import a specific sheets data from excel into access? in
microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
Discussions in microsoft.public.access.externaldata
Started 5 days, 12 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.
Thread:  Show this thread (2 posts)   Thread info: Add "Date Imported" in microsoft.public.access.externaldata Size: 403 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Add "Date Imported" in microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
Discussions in microsoft.public.access.externaldata
Started 6 days, 6 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?
Thread:  Show this thread (2 posts)   Thread info: Export Spec Problem in microsoft.public.access.externaldata Size: 309 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Export Spec Problem in microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
 

Hot threads for last week on microsoft.public.access.externaldata::

microsoft.public.access.externaldata
Started 5 days, 12 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]
Thread:  Show this thread (3 posts)   Thread info: Align Right certain fields of a query when exporting as fixed width txt
file in microsoft.public.access.externaldata Size: 485 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Align Right certain fields of a query when exporting as fixed width txt
file in microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
microsoft.public.access.externaldata
Started 6 days, 6 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?
Thread:  Show this thread (2 posts)   Thread info: Export Spec Problem in microsoft.public.access.externaldata Size: 309 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Export Spec Problem in microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
microsoft.public.access.externaldata
Started 5 days, 11 hours ago (2009-11-24 10:25:00)  by Ken Snell
DoCmd.TransferSpreadsheet acImport, , "Temp", sDir & "Jobs_Per_Prop", True, "sheetb$"
Thread:  Show this thread (2 posts)   Thread info: Possible to import a specific sheets data from excel into access? in
microsoft.public.access.externaldata Size: 335 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Possible to import a specific sheets data from excel into access? in
microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
microsoft.public.access.externaldata
Started 5 days, 12 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.
Thread:  Show this thread (2 posts)   Thread info: Add "Date Imported" in microsoft.public.access.externaldata Size: 403 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Add "Date Imported" in microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
microsoft.public.access.externaldata
Started 3 days, 9 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 ...
Thread:  Show this thread (2 posts)   Thread info: Trouble importing foreign language accents into Access 2003 in
microsoft.public.access.externaldata Size: 1,171 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Trouble importing foreign language accents into Access 2003 in
microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
microsoft.public.access.externaldata
Started 1 week, 1 day 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 ...
Thread:  Show this thread (2 posts)   Thread info: Importing FoxPro 2.6 DBF Into Access 2007 in
microsoft.public.access.externaldata Size: 2,788 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Importing FoxPro 2.6 DBF Into Access 2007 in
microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."