|
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:
|
44
|
81
|
260
|
|
Post:
|
56
|
112
|
413
|
|
|
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:
importing a text file witnh...
Published (2009-11-06 07:41:00)
I would import it into a text field. Next I would run an update query to replace all the periods "." with nothing "" using the Replace function. Then I'd run another update query, again using the Replace function, to replace the comma "," with a period ".". Then you could use the Val function to convert the text string to an actual number as needed. --...
user's latest post:
Multiple Spreadsheet Importing...
Published (2009-11-10 20:13:00)
Take a look at Ken Snell's page here: http://www.accessmvp.com/KDSnell/EXCEL_Import.htm -- --Roger Carlson MS Access MVP www.rogersaccesslibrary.com http://rogersaccessblog.blogspot.com/ "MugWump via AccessMonster.com" <u36273@uwe> wrote in message news:9eec1c241c5b2@uwe... > Hiya Folks > > So here's the deal: > > I've been asked to create a database...
user's latest post:
Importing data from Excel into...
Published (2009-11-05 12:11:00)
Can I import data from an Excel spreadsheet into an Access database and identify what information is updated and what information is not updated?
user's latest post:
Ken Snell export code in...
Published (2009-11-05 09:47:00)
I am trying to utilize two tables (customers) & (Invoices) to export filtered data to 3 separate sheets. I have seen the code in Ken snell's site yet i am not sure if this can be the soultion for me to use. Can anyone assit in directing me since it seems complicated .
user's latest post:
Issue with Data Types when...
Published (2009-11-10 17:39:00)
I should have mentioned preferably without using a data conversion functions with Access. On 9 Nov, 15:47, Robin9876 <robin9...@hotmail.com> wrote: > When linking from Access to a SQL Server table that has float fields, > is it possible that Access can return all numbers with a decimal? E.g. > 123 would return 123.0000000000 .
MugWump via AccessMonster.com
2
user's latest post:
Multiple Spreadsheet Importing...
Published (2009-11-10 20:14:00)
Sadly I have no control or say over how the spreadsheet portion works. That's a completely different ball of wax. But the spreadsheet with "09306_09311" isn't for September of 2006 -- it's for the week starting on 11/02/09 and ending on 11/06/09 -- I believe it has to do with a Julian Date (but that's just a guess, I've never seen these spreadsheets before). As for a week that crosses a...
user's latest post:
Import | and ¦ Delimted Text...
Published (2009-11-01 06:00:00)
I wish to import a delimited text file where the bar character (|) is used as the column delimiter and the broken pipe (?) is used as the record delimiter. The standard import does not allow you to specify the record delimiter. The file contains unquoted text that contains punctuation and return character codes so I can't even do a search and replace on the file prior to import. Any suggestions please?
PieterLinden via AccessMonster.com
1
user's latest post:
Import | and ¦ Delimted Text...
Published (2009-11-02 05:24:00)
Peter Schmidt wrote: >I wish to import a delimited text file where the bar character (|) is used as >the column delimiter and the broken pipe (?) is used as the record delimiter. >The standard import does not allow you to specify the record delimiter. > >The file contains unquoted text that contains punctuation and return >character codes so I can't even do a search and replace on the...
user's latest post:
Importing records in tables in...
Published (2009-11-02 00:41:00)
I have a question, I am importing data into a table, if I use a macro to create a table then 1,000 records = 1,00 records in table. If, though, I copy and Edit paste special, 1,000 records can = 900. Any thoughts? There are no filters or unique record identifiers, although the imported data cells can hold 1,500+ characters, record type is set to Memo in thse cases
user's latest post:
Convert format of date in...
Published (2009-11-01 01:58:00)
My question is how do you change the format date to another format date. for example: in my file all date like this:2009/09/14 but i want to convert to 2009-09-14 ofcourse i have done like following but noting happen: 1-Select Date in the Category list. 2- Select a date format in the Type list. Does anyone know how to do this? If anyone can offer any suggestions about how to convert date I'd love to hear them. Thanks, ashrafi...
|
|
|
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 1 day, 15 hours ago (2009-11-11 08:45:00)
by Roger Carlson
Try adding the dbFailOnError option to generate a run-time error to see
what's going on:
CurrentDb.Execute SQLstr2, dbFailOnError
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http...
Started 1 day, 15 hours ago (2009-11-11 08:20:00)
by Roger Carlson
You could export it using the TransferText method. Easiest way to create it
is to make a macro that uses the TransferText action, add the values you
want, then (after saving the macro) convert the macro to code with the
SaveAs Module option. Then you'll have the VBA code for the TransferText
method.
--
--Roger Carlson...
Started 2 days, 3 hours ago (2009-11-10 20:13:00)
by Roger Carlson
Take a look at Ken Snell's page here:
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm
--
--Roger Carlson
MS Access MVP
www.rogersaccesslibrary.com
http://rogersaccessblog.blogspot.com/
"MugWump via AccessMonster.com" <u36273@uwe> wrote in message
news:9eec1c241c5b2@uwe...
> Hiya ...
Started 2 days, 4 hours ago (2009-11-10 19:19:00)
by Roger Carlson
The following assumes:
1) The data starts at A1:A3
2) a reference to Excel and DAO set
3) the excel workbook is in the same directory as the database application
4) the three "values" are in fields: Field1, Field2, Field3 (you didn't give
the field names)
Note: It will export as many *lines* as you have in the query....
Started 2 days, 6 hours ago (2009-11-10 17:39:00)
by Robin9876
I should have mentioned preferably without using a data conversion
functions with Access.
On 9 Nov, 15:47, Robin9876 <robin9...@hotmail.com> wrote:
> When linking from Access to a SQL Server table that has float fields,
> is it possible that Access can return all numbers with a decimal? E.g.
> 123 would return 123.0000000000...
Started 6 days, 16 hours ago (2009-11-06 07:41:00)
by Jerry Whittle
I would import it into a text field.
Next I would run an update query to replace all the periods "." with nothing
"" using the Replace function.
Then I'd run another update query, again using the Replace function, to
replace the comma "," with a period ".".
Then you could use the Val function to convert the text ...
|
|
Hot threads for last week on Discussions in microsoft.public.access.externaldata:
Started 2 days, 3 hours ago (2009-11-10 20:13:00)
by Roger Carlson
Take a look at Ken Snell's page here:
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm
--
--Roger Carlson
MS Access MVP
www.rogersaccesslibrary.com
http://rogersaccessblog.blogspot.com/
"MugWump via AccessMonster.com" <u36273@uwe> wrote in message
news:9eec1c241c5b2@uwe...
> Hiya ...
Started 2 days, 4 hours ago (2009-11-10 19:19:00)
by Roger Carlson
The following assumes:
1) The data starts at A1:A3
2) a reference to Excel and DAO set
3) the excel workbook is in the same directory as the database application
4) the three "values" are in fields: Field1, Field2, Field3 (you didn't give
the field names)
Note: It will export as many *lines* as you have in the query....
Started 1 week ago (2009-11-05 10:18:00)
by Jerry Whittle
In Access 2007:
Go to the Database Tools tab.
Open up Linked Table Manager. (You might get a security warning - ignore it)
When the Linked Table Manager window opens, ckeck the Always Prompt For New
Location box towards the bottom. Click on the Select All button. Next click
on the OK button.
Then find the files...
Started 1 week, 1 day ago (2009-11-04 10:21:00)
by Roger Carlson
You have to give the specific number type, that is: integer, long integer,
single, double, byte, etc.
When you look at the design view of the table and it says Number, what is
the specific number type in the "Field Size" property below in the General
tab. That's the type you want to choose in the Spec.
--
--Roger ...
Started 1 week ago (2009-11-05 07:30:00)
by Jerry Whittle
Create a query and use the Format function to force the number of decimals
that you want to see. Then export the query.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"Yossi evenzur" wrote:
> Hi i export a table with 8 decimal places to text files and ...
Started 1 week ago (2009-11-05 07:34:00)
by Jerry Whittle
There are limits, but not that few of rows. You should be able to export
16,000 rows easily.
Describe exactly how you are doing the export to Excel. There are many
different ways and some work differently than others.
Also are you exporting memo fields? Do you get any error messages in Access.
Try this: Make a ...
Started 6 days, 16 hours ago (2009-11-06 07:41:00)
by Jerry Whittle
I would import it into a text field.
Next I would run an update query to replace all the periods "." with nothing
"" using the Replace function.
Then I'd run another update query, again using the Replace function, to
replace the comma "," with a period ".".
Then you could use the Val function to convert the text ...
Started 2 days, 6 hours ago (2009-11-10 17:39:00)
by Robin9876
I should have mentioned preferably without using a data conversion
functions with Access.
On 9 Nov, 15:47, Robin9876 <robin9...@hotmail.com> wrote:
> When linking from Access to a SQL Server table that has float fields,
> is it possible that Access can return all numbers with a decimal? E.g.
> 123 would return 123.0000000000...
Started 1 day, 15 hours ago (2009-11-11 08:45:00)
by Roger Carlson
Try adding the dbFailOnError option to generate a run-time error to see
what's going on:
CurrentDb.Execute SQLstr2, dbFailOnError
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http...
Started 1 day, 15 hours ago (2009-11-11 08:20:00)
by Roger Carlson
You could export it using the TransferText method. Easiest way to create it
is to make a macro that uses the TransferText action, add the values you
want, then (after saving the macro) convert the macro to code with the
SaveAs Module option. Then you'll have the VBA code for the TransferText
method.
--
--Roger Carlson...
|
|
Size: 4,877 bytes
