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: 18 post per thread
Forum activity: 32 active threads during last week
 

Posting activity on microsoft.public.access.externaldata:

  Week Month 3 Months
Threads: 32 120 358
Post: 72 232 655
 

microsoft.public.access.externaldata Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
Tony Williams
11
user's latest post:
Importing a date and time from...
Published (2009-01-06 11:38:00)
  Thanks Jeff I'll post back if I have any luck. Cheers and thanks again Tony "Jeff Boyce" wrote: > Aside from that puzzling last couple of characters, I believe you could use > an Access function that converts a string-that-looks-like-a-date into an > actual date/time value. > > (and I suspect those puzzling characters are the truncated version of what > originates as...
Jeff Boyce
9
user's latest post:
Extra blank records in Access...
Published (2009-01-07 13:49:00)
  Where? ... as in where have you "tried deleting all blank rows"? Regards Jeff Boyce Microsoft Office/Access MVP "kza40381" <kza40381@discussions.microsoft.com> wrote in message news:9A2586DF-1B21-47D5-AB27-61768986C7DB@microsoft.com... > Hi, > > When I link my Excel tables to my Access db, I am showing extra records in > Access which are blank records in...
Pete D.
7
user's latest post:
Access export to Excel template...
Published (2009-01-06 15:34:00)
  I think you are right that the merged cells are the problem. I think you should ask this in and excel group for more info on how to do the import and avoid the problem. "clk" <c.kurutz@comcast.net> wrote in message news:8ced5ffb-36e2-434b-8d3f-467c9cfc2a6e@r32g2000vba.googlegroups.com... > Hello. I have an Excel template where I need to export data from an > Access database (version...
Chris O'C via AccessMonster.com
3
user's latest post:
Command Button to start import...
Published (2009-01-03 06:53:00)
  Sorry, there's no built in command. Chris Tony Williams wrote: >Thanks for such a quick response Chris. That worked just fine. Is there >anyway I can force it to show Excel files only in the files to open box? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200901/1  
pietlinden@hotmail.com
3
user's latest post:
Import text file into access in...
Published (2009-01-07 17:54:00)
  Or you could do something like this, which requires an import specification, but no other references and especially not the Scripting Runtime. Public Sub ProcessDirectory(ByVal strPath As String) Dim strFileName As String strFileName = Dir(strPath & "\Data*.txt") Do Until strFileName = "" Debug.Print strFileName DoCmd.TransferText acImportDelim, "Data1 Import...
Douglas J. Steele
3
user's latest post:
How to show imported field as...
Published (2009-01-06 15:33:00)
  All you need to do is format the field as a date. Under the covers, Date values are stored as eight-byte floating point number where the integer portion represents the date as the number of days relative to 30 Dec, 1899, and the decimal portion represents the time as a fraction of a day. ?Format(39644.276782, "dd-mmm-yy") 15-Jul-08 ?Format(39637.275718, "dd-mmm-yy") 08-Jul-08 ?Format(39503,...
Ron West
2
user's latest post:
Excel & Access 2007 SP1 -...
Published (2009-01-02 08:15:00)
  When I try to copy and paste data from Excel to Access (2007 SP1), I get the following message:- "The data on the Clipboard is damaged, so Microsoft Access can't paste it. There may be an error in the Clipboard, or there may not be enough free memory. Try the operation again." There's no lack of memory that I know of - anyone have any ideas what is causing this?  
Bookmdano
2
user's latest post:
Separating Data in...
Published (2009-01-05 11:42:00)
  The data is currently displayed in a row, of which there are 3,000 rows of data. Each row looks like: 12/01/06 $2,000.00 Cisco Switch for new network I want to have each of those items in their own column. The data is not separated by commas. It appears that they are tab delimited. Thanks for your input. "Jeff Boyce" wrote: > You provided an example of what you want. > > What about an example...
ttp
2
user's latest post:
How to show imported field as...
Published (2009-01-05 07:00:00)
  I failed to mention that 15-Jul-08 and 08-Jul-08 also includes a time; but 25-Feb-08 does not include a time. "ttp" wrote: > I am importing an Excel file which contains a field with dates of the > following format: DD-MMM-YY (15-Jul-08). The table is imported as a text > field and the data is not displayed as shown in the table. For instance, > 15-Jul-08 is showing as 39644.276782 and...
Bill B
2
user's latest post:
Import Spec and date format in...
Published (2009-01-07 18:03:00)
  I have the same problem. Date imports from text data files that worked in access 2003 do not work in 2007. I found this solution on another website The only solution that I can find is to convert the text data to a date. The only workaround I can see is to import that data into a table with the date as a text field. You then simply run a update query to send this data to another column in the table (or simply build a expressin that...
 

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

Discussions in microsoft.public.access.externaldata
Started 1 day, 13 hours ago (2009-01-07 12:32:00)  by Steve_A
I have been using access 97 since about 2000 and have updated some stuff over time to 2K and XP but now I am going to 2007 and my import specifications are having problems. Most of my data comes from a mainframe and I bring it down as fixed width and most is good as I use most as “TEXT” but some have different date formats. ...
Thread:  Show this thread (4 posts)   Thread info: Import Spec and date format in microsoft.public.access.externaldata Size: 1,111 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Import Spec and date format in microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
Discussions in microsoft.public.access.externaldata
Started 2 days, 11 hours ago (2009-01-06 14:52:00)  by DRSpok
I want to put certain parts of a text file into a record in an Access table, then repeat the process several hundred times. What is the best way to accomplish this?
Thread:  Show this thread (3 posts)   Thread info: Import text file into access in microsoft.public.access.externaldata Size: 499 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Import text file into access in microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
Discussions in microsoft.public.access.externaldata
Started 1 day, 15 hours ago (2009-01-07 10:58:00)  by Stephen
When importing from Ex to Acc I sometimes receive data that looks like this:This complex will house the Station’s commanÿ䌀敨牲⁹潐湩⁴敲畱獥獴愠摤瑩潩慮畦摮湩⁧潦⁲桴⁥牰灥牡瑡潩景琠敨匠慴楴湯琠浥潰慲祲 䠠⁑湁敮⹸‮䌠敨牲⁹潐湩⁴牯 .....CAN I GET SOME HELP PLEASE?
Thread:  Show this thread (2 posts)   Thread info: Strange Text Importing in microsoft.public.access.externaldata Size: 677 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Strange Text Importing in microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
Discussions in microsoft.public.access.externaldata
Started 1 day, 15 hours ago (2009-01-07 10:20:00)  by DM - NPS
I have 2 queries in Access and I want to import the data from those queries into an Excel file (called Charts.xls). Each query and related chart will be on a different worksheet of the Excel Workbook. I tries using the do.cmd OutputTo option (tied to a command button) which allowed me to transfer the data to Excel but when I run ...
Thread:  Show this thread (2 posts)   Thread info: Import Data to Excel but Keep Chart Format in microsoft.public.access.externaldata Size: 1,043 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Import Data to Excel but Keep Chart Format in microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
Discussions in microsoft.public.access.externaldata
Started 1 day, 21 hours ago (2009-01-07 04:44:00)  by Marc M
Every month, I upload a text file with a different file name into a database. This is done as a TransferText command within a macro. Every month, I need to modify the Action Argumen called "File Name" to upload the appropriate file. I would prefer that the macro allow me to browse for the file. Is there any way to do this?...
Thread:  Show this thread (3 posts)   Thread info: Browse for file instead of modifying design every time in microsoft.public.access.externaldata Size: 709 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Browse for file instead of modifying design every time in microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
Discussions in microsoft.public.access.externaldata
Started 1 day, 11 hours ago (2009-01-07 14:28:00)  by EAB1977
I am trying to put a nice touch to the background of a chart that I have, but I keep getting a Error 1004 Application object error on this part of the code: .Selection.Fill.OneColorGradient Style:=msoGradientHorizontal, _ Variant:=1, Degree:=0.36 I am doing Excel automation from Access and I get ...
Thread:  Show this thread (1 post)   Thread info: Help with a Chart Fill from Access to Excel in microsoft.public.access.externaldata Size: 857 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Help with a Chart Fill from Access to Excel in microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
Discussions in microsoft.public.access.externaldata
Started 1 day, 14 hours ago (2009-01-07 11:42:00)  by kza40381
Hi, When I link my Excel tables to my Access db, I am showing extra records in Access which are blank records in my Excel Files. I have tried deleting all blank rows, but this does not correct the problem. Any Suggestions?
Thread:  Show this thread (2 posts)   Thread info: Extra blank records in Access which are blank records in Excel Fil in microsoft.public.access.externaldata Size: 578 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Extra blank records in Access which are blank records in Excel Fil in microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
Discussions in microsoft.public.access.externaldata
Started 2 days, 11 hours ago (2009-01-06 14:33:00)  by DRSpok
I would like to have certain information from part of a text file imported into Access, and then repeat the process several hundred times. What is the best way to accomplish this?
Thread:  Show this thread (2 posts)   Thread info: Editing a text file to import into access in microsoft.public.access.externaldata Size: 514 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Editing a text file to import into access in microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
Discussions in microsoft.public.access.externaldata
Started 2 days, 18 hours ago (2009-01-06 07:05:00)  by clk
Hello. I have an Excel template where I need to export data from an Access database (version 2003). I have the following code working .... somewhat. There are 294 records to export but when it gets to Excel only 98 records are visible. I suspect it has to do with the fact that there are merged cells in the template I am exporting ...
Thread:  Show this thread (2 posts)   Thread info: Access export to Excel template with merged cells in microsoft.public.access.externaldata Size: 6,215 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Access export to Excel template with merged cells in microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
Discussions in microsoft.public.access.externaldata
Started 3 days, 11 hours ago (2009-01-05 14:17:00)  by frandk
When I exported a query to excel the column that holds the email addresses adds after the .com - #mailto:then the original email address again with another pound sign at the end. What am I doing wrong. -- frandk
Thread:  Show this thread (4 posts)   Thread info: email addresses double when exporting query to excel in microsoft.public.access.externaldata Size: 566 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "email addresses double when exporting query to excel 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 3 days, 15 hours ago (2009-01-05 10:48:00)  by Tony Williams
I am trying to import a spreadsheet which has two columns which hold data as a date and time like this 02/06/2006 17:26:36:2 I have tried importing the columns formatted as dates but I get a conversion error and none of the data is imported. I realise that I could split the row into 2 and then import them seperately but I ...
Thread:  Show this thread (9 posts)   Thread info: Importing a date and time from Excel in microsoft.public.access.externaldata Size: 986 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Importing a date and time from Excel in microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
microsoft.public.access.externaldata
Started 5 days, 19 hours ago (2009-01-03 06:03:00)  by Tony Williams
Can anyone provide me with the code I would need to put behind a commnad button on a form to start the import spreadsheet wizard? Thanks Tony
Thread:  Show this thread (5 posts)   Thread info: Command Button to start import in microsoft.public.access.externaldata Size: 485 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Command Button to start import in microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
microsoft.public.access.externaldata
Started 3 days, 16 hours ago (2009-01-05 09:48:00)  by Bookmdano
I have an old excel file that has mutiple data in each of the rows. I would like to separate the data and create a column for each category (date, amount, vendor name and description.) ex. Date, Amount, Vendor Name, Description row 1: 12/02/06 $2,000 Cisco Swtich for new Network Any suggestions? I am a ...
Thread:  Show this thread (5 posts)   Thread info: Separating Data in microsoft.public.access.externaldata Size: 725 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Separating Data in microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."
microsoft.public.access.externaldata
Started 4 days, 22 hours ago (2009-01-04 03:58:00)  by Tony Williams
I get a spreadsheet that contains data I need to add to an existing table. However some of the spreadsheet data is to update cureent records and some is to be added as new records. I imagined I could do this with two queries an append query and an update query but I'm not sure how I would get the queries to work from the import. How do ...
Thread:  Show this thread (5 posts)   Thread info: Importing from a spreadsheet, update or append query? in microsoft.public.access.externaldata Size: 1,144 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Importing from a spreadsheet, update or append query? in microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."