Sitemap

Amicuk Programming Answers

Microsoft Access 2003 - Import xls issue

-0001-11-30   Views:0

Advertisement

I'm having an issue with oracle SQL developer which exports an xls file then I proceed to import that xls in Microsoft Access 2003. I got a following error message related to the headings. "The first row contains some data that can't be used for vali

I'm having an issue with oracle SQL developer which exports an xls file then I proceed to import that xls in Microsoft Access 2003. I got a following error message related to the headings.
"The first row contains some data that can't be used for valid Access field names. In these cases, the wizard will automatically assign field names."
If I proceed with this issue in Access, it'll bring up an error message about importing the xls in Access.
I have a solution by removing the trailing column via Excel application then import the xls. I wonder any one have any better wayaround this issue?
I have the latest version and it has 2 patches.
Thanks in advance.

The replay answer
Advertisement
I forgot to mention the last column has some trailing spaces in the first row.

Go to See the other 2 answers

Microsoft Access 2003 - Import xls issue

Category:DefaultRelease time:-0001-11-30Views:130

I'm having an issue with oracle SQL developer which exports an xls file then I proceed to import that xls in Microsoft Access 2003. I got a following error message related to the headings. "The first row contains some data that can't be used for vali[More]

Compact and Repair Anomaly in Microsoft Access 2003 - dupicate key repair

Category:DefaultRelease time:-0001-11-30Views:130

Can anyone explain the anomaly below where "Compact and Repair" is less functional on System A?  System A:       Microsoft  Access 2003 v11.8321.8403 SP3 on Windows XP SP3  System B:        Microsoft  Access 2003 v11.8166.8172 SP3 on Windows 7 H[More]

Word 2003 Import - TOC Issue

Category:DefaultRelease time:2015-10-11Views:130

I have a problem when importing docs into RoboHelp HTML X5.02 from Word 2003. The TOC generates with the correct structure based on the TOC from my document, but the generated Topics are not linked to the TOC books/pages that have been created. I am[More]

Can I use Web Services with Microsoft Access?

Category:DefaultRelease time:-0001-11-30Views:130

I'm somewhat handy with Microsoft Access (2003 in particular), but not an expert. Macros? No problem. VBA? I'd be hard pressed to code anything from scratch, but I'm not too bad with modifying code/examples to fit my particular scenario. So, if anyth[More]

Access 2003 - Repeated "You cant make changes to the database" error

Category:DefaultRelease time:-0001-11-30Views:130

Hey all, Im having a very strange problem with Microsoft Access 2003, we work with old databases and when we open them up through Access 2003 we get the message "you cant make changes to the database objects" error, which is expected. However th[More]

Microsoft Access Database can't be accessed at times

Category:DefaultRelease time:-0001-11-30Views:130

Just wondering if anyone else is having troubles with running a Microsoft Access 2003 running on OES 11 SP1? Not sure what is causing it but everyone once and a while our database is only accessible to one person at a time. We can run weeks at time w[More]

Microsoft Access

Category:DefaultRelease time:-0001-11-30Views:130

I am using Crystal Reports 10 for Sage.  I created an Access Database using Microsoft Access 2003.  I am using Sage PFW.  The report works well when running it from Crystal Reports, but when I run the report through Sage PFW, the database is deleted[More]

How do I obtain 'Save As PDF' option in MS Access 2003?

Category:DefaultRelease time:-0001-11-30Views:130

Ever since I installed the Adobe CS2 Premium Suite (containing a full copy of Acrobat) on my PC a long time ago, the main menu of Microsoft Access 2003 has contained an item that would let me save an Access report as a PDF. I have since upgraded to A[More]

SQL Exoress 2008 import export Wizard wont import Access 2003 mdb to SQL 2008 DB

Category:DefaultRelease time:-0001-11-30Views:130

Just installed SQL Express with Tools, including SSME and Import Export Wizard. Attempted to transfer Access 2003 DB tables from an mdb file to a SQL 2008 Express DB. I can view the data in the tables in Access, however, when I tell it to  do the dee[More]

Is there any way of importing stuffs from Microsoft Access to SQL Server?

Category:DefaultRelease time:2015-10-11Views:130

I have quite a big store of information Microsoft Access DB, but now i am required to switch to SQL Server? Is there any way of importing to SQL Server, either by Java programming or manually? Thank you in advance.I like to give some tips on how to f[More]

Trying to Import data from Microsoft Access in POWERPIVOT

Category:DefaultRelease time:-0001-11-30Views:130

Hello, I am trying to import data from Microsoft Access into Powerpivot. In my Access database I have several query's. When I go to the Table Import Wizard in powerpivot, I only see one source table. Why can't I see the other query's? Thanks in advan[More]

Hot
My hard-drive crashed, I own Lightroom 5, where can I download it again t re install it. The ADOBE email I had has links that no longer work (thanks for that). Running Windows 7 Home PremiumHello Andrea, did you try this: http://www.adobe.com/cfusion [More]
Sorry for another stupid question.... I have a query which runs of a search.... the query results... i want to add an edit image so it goes to another page where users can change the data can someone help me with this please nb: any good book i can b [More]
I'm trying to install Windows Vista on my Mac. Do I need the Leopard disc in order to complete the installation because I don't have it.Hi, Sorry, I don't know much about Boot Camp, but you might get more help posting this in the Boot Camp forum as w [More]
Hi to all, We've planned to migrate oracle 9i to oracle 10g. Sys DBA will do the migraion.I'm App DBA and i want to know what are all the feature the not support in oracle 10g comparing to oracle 9i. Please give information in details. Thanks in adva [More]
   Hi sir, I am running concurrent program,that is taking time to execute ,i want to know which sql query causing performance Thanaks, SreekanthHi, My Learning: Diagnosing Oracle Applications Concurrent Programmes - 11i/R12 How to run a Trace for a C [More]
BT are dealing with this so am not seeking solutions but before contacting them I saw other threads on this which didn't seem to answer the basic questions so am posting for reference only for others with this problem. My handset(s) weren't ringing e [More]
Hello everyone, I'm trying to figure out how to execute a search in a WebHelp output by calling it from the URL, just like I do with map IDs. Basically, I'd like to do something like this: http://www.myserver.com/help/robohelp/index.htm?search=mysear [More]
I would like to create a smart playlist that contains albums that are in one playlist but not another.  It would be great if there was a smart criteria operator like " [Album] [is in playlist] [Playlist]", but unfortunately the only album operat [More]
When streaming music or video from the NAS to my desktop across a wired LAN, the music and video occasionally drops out or studders.  It appears that the transfer data rate drops to zero (0) and then resumes.  Doesn't seem to matter what player I use [More]
I have a dimension time and a table in which there are some rows with the same date: i.e. DATA OP DESCRIPTION      09-02-2002 64.54 xxxx      09-02-2002 24.63 yyy      But on my workbook I can't see these rows. I see empty fiels. The sqlinspector giv [More]