Summary: Good morning. I am trying to import an Excel spreadsheet to a Access table that I have already started. When the import wizard shows whether you want ...
Summary: Just some clarification - I have about 1500 dates in Excel with the format 12/11/2001. I am inporting them into a database that has to have the impor...
Summary: Copy all to a text file and next import it in excel, usin conversion tool.If u open a .txt file with xl, conversion tool is auto launched, and u can d...
Summary: I am trying to import TXT, and CSV files to Access 97. When I choose import, TXT and CSV are not options. I have installed EVERYTHING from the Office ...
Summary: HI Qbart I went to your side, and yes there are ways of doing this in a macro, or several macros, but this is almost better done in MS Access, a coupl...
Summary: I have imported a list of contacts into excel, I have about 550 email addresses. They are just text though, I'd like the to all be clickable email add...
Summary: Open Access Create a new database In a new Table File Get External Data Import Files of Type Microsoft Excel (xls) Browse to your Excel Spreadsheet Fo...
Summary: You won't know until you try.. First, make a copy of the database (I assume you mean Excel Workbook, and not Access database). If the file is stored...
Summary: I need some help with a formula in Excel 03. I have two Excel workbooks. The first WB is a financial report that I am importing data into. I am import...
Summary: I have a folder full of DAT files (210) that I want to import into excel with each dat file being imported into its own worksheet. The DAT files have ...
Summary: On the Excel search, I've decided jus to use the Windows search for right now. I'm under a time constraint and by the time I learned enough VBA, I'd b...
Summary: Are you selecting "Text Files" as the import filetype? If the file is a csv file, then the comma is the field separater. Life is more painless for th...
Summary: Hi, I was just wondering if there is a way of formatting the following... I have a SAP report that i transfer into an excel sheet. Once I import the i...
Summary: No macro needed. Select all, copy in wordpad ans save as .txt. Next open it with excel, conversion/import tool will open automatically. Follow instruc...
Summary: open it up in open office's spreadsheet application and save as CSV - don't think you can do this in Excel - if not it's a fairly simple programming e...
Summary: I have a an excel spreadsheet and an access database. I need to take some specific data from access to excel. Normally I would import the data into e...
Summary: Not sure about Excel but there are lots of telemarketing packages around which may work with Excel or import from it. Example: http://www.modem-softwa...
Summary: Outlook 2003 SP2: XP Pro My Main "Contacts" "Current View" "Address Cards", I see ALL my contacts (Home, Business, etc)with their e-mail adresses - i...
Summary: I have a Lotus Approach 97 project that I wish to convert to Excel (files are .apr, .apx and the database file). Is there a conversion program availab...
Summary: i want to import an excel 2003 spreadsheet into access 2003. i know the correct procedure to do this: File/GetExternalData/Import and i choose the loc...
Summary: OK, I've come up with a work around... I copied the two columns into a new spreadsheet, and saved as CSV. The open the CSV in notepad and remove all ...
Summary: The data file is a bad CSV. The number of fields is not fixed (bad data entry probably). Since you appear to be a hospitality wholesaler, you are pr...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
