Type Conversion Issue - Linking Excel Tables

T

TIFFANY

Hi Everyone I need some help...
Here's my scenario and problem:

**10 Excel tables on network drive and are maually updated
on a daily basis...text is sometimes put in DATE formatted
columns.

**I need to LINK these 10 tables into ONE large table in
my database that will show both the DATE format and TEXT
format.

I'm getting a data type conversion error when linking
these tables to my database. The DATE formatted columns
have some data as TEXT (such as "done" "finished" "in
process"). How do I convert those tables to TEXT files
upon linking to my database so that ALL information
whether number or text shows up???

thank you so much for your help!
Tiffany
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidation Table from Different Excel Tabs with Different Format 1
Linking data in MS Word into Excel 5
Construct table from selected rows 4
Query to show details of dataset when one type of data is still blank 1
Extracting just the time portion 6
Data Type Issue in Linked Excel Table 7
Link to excel table which has keys in both row and col headers: isthis possible? 0
Need to change cell reference of an already linked Excel data set 0

Top